topic date format in Application Development and Automation Discussions

date format

Former Member — Sat, 17 Dec 2005 09:37:30 GMT

Hi everybody...

In my input file ,DATE field having 3 different formats

that are dd/mm/yyyy , dd.mm.yyyy and

dd-mm-yyyy.

my doubt is ,how to convert above mentioned date formats into yyyymmdd format .

Re: date format

Former Member — Sat, 17 Dec 2005 09:40:20 GMT

use the Function module

CONVERT_DATE_TO_INTERNAL

to convert dd/mm/yyyy to yyyymmdd.

regards

vijay

Re: date format

Former Member — Sat, 17 Dec 2005 09:47:09 GMT

replace '.' with '/' dd.mm.yyyy

replace '-' with '/' dd-mm-yyyy

REPLACE ALL OCCURRENCES OF '.' IN date WITH '/'. 
REPLACE ALL OCCURRENCES OF '-' IN date WITH '/'.

and use this fm CONVERT_DATE_TO_INTERNAL

make sure you should move the date to char 10 and do replace...

regards

vijay

Re: date format

Former Member — Sat, 17 Dec 2005 09:54:47 GMT

In all formats you have the date is always:

DDsMMsYYYY

where s is a separatore and it can be /,. or -, but this isn't important for you, because where the numbes (days, month and year) of day should be important.

The first second positions are always the day, fourth and fifth positions are the month and the last four positions are the year.

So you can always to do:

DATA: DAY_OUT LIKE SY-DATUM.

WRITE: DAY_IN+6(4) TO DAY_OUT(4),

DAY_IN3(2) TO DAY_OUT4(2),

DAY_IN(2) TO DAY_OUT+6(2).

or also:

CONCATENATE DAY_IN6(4)DAY_IN3(2)DAY_IN(2)INTO DAY_OUT.

Max

Re: date format

Former Member — Sun, 18 Dec 2005 02:52:01 GMT

If it is always in DDxMMxYYYY format then you can simply do:

<b>concatenate input_date+6(4) input_date+3(2) input_date(2) into output_date.</b>