WRKQRY date conversion

[satish]

Hi,

I have a date in YYYYMMDD with dec (8,0) format. I want to convert this into MMDDYYYY format.

Note that this a numeric field i cant use substring and rearrange it.

[jamief]

Re: WRKQRY date conversion

this old page should help

http://www.code400.com/query400.php

jamie

[satish]

Re: WRKQRY date conversion

Hi jamie,

Thanks a lot. i used DIGITS function. it worked for me.