topic Re: func that change date in Application Development and Automation Discussions

func that change date

Former Member — Mon, 19 Dec 2005 11:23:40 GMT

i have date like 01.09.2005

and i want to get it in this format---20050901

is there func that doing it.

Re: func that change date

Former Member — Mon, 19 Dec 2005 11:27:18 GMT

Hi Liat,

Check the function modules

<b>CONVERT_DATE</b>* .

May be one of the function modules gives you the

desired result.

Thanks&Regards,

Siri.

Re: func that change date

Former Member — Mon, 19 Dec 2005 11:28:41 GMT

try

CONVERT_DATE_TO_INTERN_FORMAT

Re: func that change date

Former Member — Mon, 19 Dec 2005 11:30:11 GMT

what is the type you know?

Re: func that change date

Former Member — Mon, 19 Dec 2005 11:31:16 GMT

Hi Liat,

1. User FM

CONVERT_DATE_TO_INTERN_FORMAT

2. In the paramaeter DTYPE

pass DATS

I hope it helps.

Regards,

Amit M.

Re: func that change date

manuel_bassani — Mon, 19 Dec 2005 11:33:29 GMT

you can also use a simple conversion like:


DATA: dat1(10),
      dat2(10).

write sy-datum to dat1.

concatenate dat1+6(4) dat1+3(2) dat1(2) into dat2.

Regards, Manuel

Re: func that change date

Former Member — Mon, 19 Dec 2005 11:35:15 GMT

if you are very sure of DATE format is like given below,

use the OFFSET .

ex :

data : v_date(10) type c value '10.12.2005',

v_datum type sy-datum.

concatenate v_date+6(4)

v_date+3(2)

v_date+0(2)

into v_datum

NOW v_datum will have 20051210.

regads,

srikanth

Re: func that change date

Former Member — Mon, 19 Dec 2005 11:39:38 GMT

Hi Liat,

There's a function called CONVERT_DATE_TO_INTERN_FORMAT

which will convert the date you entered to the system format of YYYYMMDD. For the parameter DTYPE use 'DATS'.

Also, the date must be in the format that is specified under Defaults of your user profile otherwise you'll get an exception of invalid date.