topic Re: regarding date conversion in Application Development and Automation Discussions

regarding date conversion

Former Member — Tue, 05 Jun 2007 06:53:53 GMT

i have a date in the format of 20070530

now i want the date to be int the format of 30/05/2007.

how can i do that.

thanks in advance

Re: regarding date conversion

sreeramkumar_madisetty — Tue, 05 Jun 2007 06:56:38 GMT

Use the Split and Concatenate mechanism.

g_date = sy-datum.

concatenate g_date0(4) '/' g_date4(2) '/' g_date+6(2) into g_date.

Regards,

Sree

Re: regarding date conversion

Former Member — Tue, 05 Jun 2007 06:56:46 GMT

Use

WRITE date MM/DD/YYYY.

or use FM CONVERT_DATE_TO_EXTERNAL

Regards,

Atish

Re: regarding date conversion

Former Member — Tue, 05 Jun 2007 06:56:58 GMT

HI,

data: Date type Sy-datum,
        date1(10) type c.

Date = sy-datum.

Write Date to Date1.

write:/ date1.  " This will have the format which you asked

Regards

Sudheer

Re: regarding date conversion

Former Member — Tue, 05 Jun 2007 06:57:00 GMT

Do the offset for the date field by splitting into YEAR(first 4 char), Month(next 2 char) and DATE (last 2 char) and concatenate them into a string as per your requirement

or Use EDIT mask command for wrirting this format

Reward points if useful

Regards

Anji

Re: regarding date conversion

Former Member — Tue, 05 Jun 2007 06:57:15 GMT

Hi,

you can use offsets to change format what you want.

or use statemetn like "write: date1 to date2" converts date as per user settings.

Sudheer.A

Re: regarding date conversion

Former Member — Tue, 05 Jun 2007 06:57:15 GMT

hi,

In the menu bar Goto->System->User Profile->Owndata->Defaults.

There u have the options and u can select the date format which u want.

Message was edited by:

Roja Velagapudi

Re: regarding date conversion

Former Member — Tue, 05 Jun 2007 06:57:55 GMT

write : itab-date using edit mask '__/__/____'.

data : date(10).

concatenate sy-datum6(2) sy-datum4(2) sy-datum+0(4) into date separated by '/'.

write : date.

regards

shiba dutta

Re: regarding date conversion

amit_khare — Tue, 05 Jun 2007 06:57:59 GMT

Try FM - DATE_STRING_CONVERT

Regards,

Amit

Reward all helpful replies.

Re: regarding date conversion

Former Member — Tue, 05 Jun 2007 07:00:21 GMT

Do Like This........

Data:Date Type sy-datum,date1(2),month(2),year(4),final_date(10).

date1 = date+6(2).

month = date+4(2).

year = date+0(4).

concatenate date month year into final_date seperated by '/'.

Reward All Helpfull Answers..........