topic Re: Date format in Application Development and Automation Discussions

Date format

Former Member — Wed, 13 Aug 2008 06:54:18 GMT

Hi all,

I got a date which is in the format YYYY.MM.DD hh:mm:ss

I need to convert this to YYYY-MM-DD-hh.mm.ss

Please help.

thanks.

Re: Date format

Former Member — Wed, 13 Aug 2008 06:55:47 GMT

Hi ,

u can use keyword REPLACE.

Regards

Prabhu

Re: Date format

peter_ruiz2 — Wed, 13 Aug 2008 06:56:48 GMT

hi,

use this.

REPLACE '.' WITH '-' INTO field.

REPLACE ':' WITH '-' INTO field.

regards,

Peter

Re: Date format

Former Member — Wed, 13 Aug 2008 06:56:53 GMT

Hi!

REPLACE ALL OCCURRENCES OF '.' IN gv_string WITH '-'.

REPLACE ALL OCCURRENCES OF ':' IN gv_string WITH '.'.

Regards

Tamá

Re: Date format

Former Member — Wed, 13 Aug 2008 06:56:57 GMT

HI,

YYYY.MM.DD hh:mm:ss

REPLACE ALL OCCURENCES OF '.' WITH '-' AND

':' WITH '.' IN v_date.

Re: Date format

Former Member — Wed, 13 Aug 2008 06:59:09 GMT

hiii

use like below code

wa_date = '2008/08/08'.

something like:

CONCATENATE wa_date0(4) '-' wa_date5(2) '-' wa_date+8(2) INTO wa_new_date.

regards

twinkal

Re: Date format

Former Member — Wed, 13 Aug 2008 06:59:49 GMT

Hi,

Try this way,,,that will solve ur issue.

concatenate date '-' time into field1.

Hope it is helps,

Regards,

T.D.M.

Re: Date format

Former Member — Wed, 13 Aug 2008 07:00:09 GMT

Hi,

You can use Edit mask option for WRITE statement while displaying.

-Vikas

Re: Date format

Former Member — Wed, 13 Aug 2008 07:08:02 GMT

Hi,

go through following piece of code... and do changes where required ....

data : s_date like sy-datum,

s_date1(10).

data : s_time like sy-uzeit,

s_time1(8).

data : t_stamp(14) value '20070522064742'.

s_date = t_stamp+0(8).

s_time = t_stamp+8(6).

write s_date to s_date1.

write s_time to s_time1.

concatenate s_date1 s_time1 into t_result separated by space.

i hope u will get some help fron this

Thanks & Regards

Ashu Singh