convert date to julian date

[Bon]

Is there a way to convert a standard date (i.e.
07/03/2003) to a julian date (i.e. 37805) in an Access
2000 mdb query?

 

[chas]

Hi Bon,

take a look at the following Microsoft article:

http://support.microsoft.com/?id=209922

(ACC2000: How to Convert Julian Days to Dates in Access
and Back)

hth

chas