Converting Julian Date to mm/dd/yy in query

[Guest.Visitor]

I need to convert a julian date YYYYDDD into MMDDYY within query. I found a thread from 1997 but only found the first question but not the answers. Thanks for any help

[Guest.Visitor]

Tracy, The following will convert a julian numeric date into a character field representation of mm/dd/yy. If you want this as a character rep without the slashes, just create another field substringing them out.

 Field Expression Column Heading Len Dec JULA digits(jul) JULD date(jula) MDYA char(juld) 

Here, the field JUL is a numeric field representation of -either- YYYYDDD or YYDDD. The field JULD is a date field that will print out in the job's date format (probably mm/dd/yy). The field MDYA is a character field that prints just like JULD (whatever the job's date format). If you happen to be running a date format differently, then just substring and concatenante MDYA into the appropriate format. Bill