date format

[Former Member]

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

[Former Member]

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

[RichHeilman]

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

[Former Member]

Thanks Rich.

[Former Member]

Hi,

Alternatively you can use concatenate statement.

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

[Former Member]

Thanks a lot