topic Re: date conversion in Application Development and Automation Discussions

date conversion

Former Member — Wed, 20 Sep 2006 06:42:49 GMT

Hi all,

My requirment is to convert 20060917 to 17.09.2006.HOw is it possible pls help me on this.

Re: date conversion

Former Member — Wed, 20 Sep 2006 06:44:12 GMT

use fm.

CONVERSION_EXIT_PDATE_OUTPUT

Re: date conversion

Former Member — Wed, 20 Sep 2006 06:44:32 GMT

data v_date(10) type c.

<b>write sy-datum to v_date.</b>

v_date will have date in your required format.

its based on user profile settings.

example:

if the user has mm/dd/yyyy format,

you will get the output also like that.

Regards

Srikanth

Re: date conversion

Former Member — Wed, 20 Sep 2006 06:49:10 GMT

d1 = 20060917

d20(2) = d16(2).

d22(2) = d14(2).

d24(4) = d10(4).

try this out

Re: date conversion

Former Member — Wed, 20 Sep 2006 06:55:17 GMT

data: datum(10) type c.

call function 'CONVERT_DATE_TO_EXTERNAL'
exporting
date_internal = sy-datum
importing
date_external = datum.

write:/ datum.

Re: date conversion

former_member184495 — Wed, 20 Sep 2006 07:00:40 GMT

hi,

try this FM CONVERT_DATE_TO_INTERN_FORMAT

or as one of our friends suggested, use offset for dd mm yyyy and then concatenate it with '.'

cheers,

Aditya.

Re: date conversion

anversha_s — Wed, 20 Sep 2006 07:04:57 GMT

hi,

alex

use this.

CONVERSION_EXIT_SDATE_OUTPUT

DATA: INT_DATUM LIKE SY-DATUM VALUE '19940102',

EXT_DATUM(11) TYPE C.

...

CALL FUNCTION 'CONVERSION_EXIT_SDATE_OUTPUT'

EXPORTING

INPUT = INT_DATUM

IMPORTING

OUTPUT = EXT_DATUM.

Result:

EXT_DATUM = 02.JAN.1994

rgds

anver

Message was edited by: Anversha s

Re: date conversion

Former Member — Wed, 20 Sep 2006 07:46:32 GMT

WRITE sy-datum to ldate DD/MM/YYYY.

The above should do the trick !!

Re: date conversion

Former Member — Wed, 20 Sep 2006 07:49:33 GMT

Hello,

Use the conversion exit CONVERSION_EXIT_PDATE_OUTPUT.

Regs,

Venkat Ramanan N