Julian Date with day always 1

[Anonymous]

Hello everyone.  I have a date column with five digit dates (Julian, I think) that I need to convert to m/d/yyyy.  I tried

Date(datefield, 'm/d/yyyy') as new date

However, the dates look like (for example) 0/1/2015 after conversion of a date 42339.  The original data appears to have the month, a 1 for the day (always) and the year for this column.  The correct answer for this date should be 8/1/2015.

Any ideas?  Thanks

[swuehl · Accepted solution]

Try

Date(datefield, 'M/D/YYYY')

(month format code is 'M', 'm' denotes minutes, see the help for details on format codes)

[Anonymous]

Thank you.  So simple!!!