Converting Julian Date 1

[SethP]

I have several tables, that when imported from our AS400 system, convert the date as Julian values. I would like to add a formula to a query that converts the Julian format into a legible date format.
Any suggestions?

Here's an example -
TM_DATE_EXPIRED_JULIAN_1 = 110365
The true date is 12/31/10

 

[PHV]

Like this ?
DateSerial(1900+(TM_DATE_EXPIRED_JULIAN_1\1000), 1, TM_DATE_EXPIRED_JULIAN_1 Mod 1000)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[SethP]

Thanks!
This worked perfectly.