topic Re: Change format date in Application Development and Automation Discussions

Change format date

Former Member — Tue, 19 Dec 2006 08:48:46 GMT

Hello,

I want to change the format date from 15 december 2006 to 15122006.

How can you do this ?

anversha_s — Tue, 19 Dec 2006 08:53:32 GMT

hi,

pls chk this table

T247

using this table u can solve this.

Rgds

Anver

Former Member — Tue, 19 Dec 2006 08:56:40 GMT

What you need to do is to take the extract the name of the month

and then use the Table <b>T247</b>

Also check out the FM <b>CONVERSION_EXIT_IDATE_INPUT</b>

You could do a workaround with this also..

amit_khare — Tue, 19 Dec 2006 08:57:28 GMT

Hi,

you may use this code.

Data: v_month(10) type c,

v_day(2) type c,

v_year(4) type c,

v_final(10) type c.

v_month = v_date+3(8).

v_day = v_date+0(2).

v_year = v_date+11(4).

case v_month.

when' January' or 'JANUARY' or 'january'.

v_mth = 1.

when' FEbruary' or ...

...

endcase.

concatenate v_date v_month v_year into v_final.

P.S. change the lengths as per your requirements.

Regards,

Amit

Reward all helpful answers.