topic universally valid solution in Application Development and Automation Discussions

universally valid solution

Former Member — Thu, 27 Mar 2008 11:13:43 GMT

Dear All!

I'm having the following problem:

I need an universally valid solution or a Function Module

which converts almost every date format

from ->

MM/DD/YYYY, DD.MM.YYYY, MM-DD-YYYY, YYYY-MM-DD etc

to ->

YYYYMMDD

Suppose the user may have different date

format and prior calling my own FM

a need the date finally as YYYYMMDD.

regards

sas

Re: universally valid solution

abapdeveloper20 — Thu, 27 Mar 2008 11:32:44 GMT

Hi erdem,

Can u pls check the below function module

CONVERT_DATE_TO_INTERNAL

Note :

Use the functions modules CONVERT_DATE_TO_EXTERNAL or CONVERT_DATE_TO_INTERNAL

to convert the date.

When converting to external format, the date format from the user's user profile will be used.

When converting to internal format, the result will be in YYYYMMDD format.

Reward if useful

~_Lakshmiraj~

Re: universally valid solution

Former Member — Thu, 27 Mar 2008 12:41:23 GMT

Dear LAKSHMIRAJ

when I call CONVERT_DATE_TO_INTERNAL

with the following date 04/24/2007 I get for example

the error message Enter a valid date .

Is it not possible to populate DATE_EXTERNAL parameter

like 04/24/2007 ?? Then this is not the correctly FM

Regards

sas

Re: universally valid solution

Former Member — Thu, 27 Mar 2008 16:04:33 GMT

Hello,

FM CONVERT_DATE_TO _INTERNAL will take as input any valid external format date and return a date in internal format.

In your example dd/mm/yyyy is not(in my system) a valid external date format. It is not possible for a user to set their date format in this way. dd.mm.yyyy is a valid format and when I test CONVERT_DATE_TO INTERNAL using a date of that format and after changing the default for my user data to dd.mm.yyyy the FM works as expected.

So using CONVERT_DATE_TO_INTERNAL should be as close to universal as you can get.

Hope this helps

Regards

Greg Kern

Re: universally valid solution

franois_henrotte — Thu, 27 Mar 2008 16:11:46 GMT

you just have to convert special characters to points before calling conversion routine


TRANSLATE my_bad_date USING '/.-.:.'.