topic Re: Date Conversions in Application Development and Automation Discussions

Date Conversions

Former Member — Tue, 08 May 2007 10:34:12 GMT

Dear All,

I badly need help in Date conversions. I am getting the date in the format say

22122007 (DDMMYYYY) can you help me in converting this to 22.12.2007 (DD.MM.YYYY).

Any help in this regard would be very very helpful.

Thanks a Lot In Advance,

Vinay

Re: Date Conversions

Former Member — Tue, 08 May 2007 10:36:29 GMT

data : v_date1(8) value '22122007',
         v_date2(10).

concatenate v_date1+0(2) v_date1+2(2) v_date1+4(4) into v_date2 separated by '.'.

write : v_date2.

Re: Date Conversions

ashok_kumar24 — Tue, 08 May 2007 10:37:04 GMT

Hi Vinay

<b>Converting dates</b>

<b>DATE_CONV_EXT_TO_INT Conversion of dates to SAP internal format e.g. '28.03.2000' -> 20000328 Can also be used to check if a date is valid ( sy-subrc <> 0 )</b>

Good Luck and thanks

Re: Date Conversions

Former Member — Tue, 08 May 2007 10:38:45 GMT

data : dt(10) value '22032007'.

write : / dt using edit mask '__.__.____'.

regards

shiba dutta

Re: Date Conversions

sreeramkumar_madisetty — Tue, 08 May 2007 10:38:51 GMT

data: g_date(10) type c.

g-date = sy-datum.

CONCATENATE g_date6(2) '.' g_date4(2) '.' g_date+0(4) INTO g_date.

Regards,

Sreeram

Re: Date Conversions

Former Member — Tue, 08 May 2007 10:39:12 GMT

hi,

take variables V1, V2, V3.

V1 = date+0(4).

V2 = date+4(2) or 5(2). Check it

V3 = date+6(2) or 7(2). check it.

Concatenate V3 V2 V1 into date separated by '.'

Now, date will have DD.MM.YYYY

Regards

Reshma

Re: Date Conversions

Former Member — Tue, 08 May 2007 10:39:28 GMT

DATA TIME TYPE T VALUE '154633'.

WRITE (8) TIME USING EDIT MASK '__:__:__'. "Output: 15:46:33

Regards

prabhu

Re: Date Conversions

Former Member — Tue, 08 May 2007 10:40:38 GMT

Try like this

DATA: v_date type d.

v_date = '22122007'.

write:/(10) v_date using edit mask '__.__.____'.

Regards

Haritha.

Re: Date Conversions

valter_oliveira — Tue, 08 May 2007 10:45:22 GMT

Hi.

Very simple, always works, and uses the user definitions.

Write your source field (dats) to a target char(10) field like this:

WRITE: source to target DD/MM/YYYY.

Hope this helps.

Reward helpfull ideas.

Best regards.

Valter Oliveira.