topic Re: date format in Application Development and Automation Discussions

date format

Former Member — Tue, 12 Jul 2005 16:45:03 GMT

hi folks,

I am reading the date from the table in 'mmddyyyy' and I want to modify the date to this format 'mm/dd' how to do that?

thanks

Santhosh

Re: date format

RichHeilman — Tue, 12 Jul 2005 16:51:04 GMT



data: date(10) type c value '07122005'.
data: monthday(5) type c.

monthday+0(2) = date+0(2).
monthday+2(1) = '/'.
monthday+3(2) = date+3(2).


Write monthday.

Just wondering why the data is being stored like mmddyyyy. Shouldn't it be being stored as yyyymmdd?

Regards,

Rich Heilman

Re: date format

Former Member — Tue, 12 Jul 2005 17:12:06 GMT

Hi,

Alternatively you can use concatenate statement.

concatenate date0(2) date2(2) into monthday separated by '/'.

Re: date format

Former Member — Tue, 12 Jul 2005 18:31:15 GMT

Thanks Rich.

Re: date format

Former Member — Tue, 12 Jul 2005 18:31:33 GMT

Thanks a lot