How convert date to julian day ???

[Dylan]

I have an access report that I want to take a text box that contains a date and convert it to to a Julian day.

example 03/31/03 is equal to julian day 090
(asumming 28 days in Feb)

Thanks for any help

Tom Moran
Lansing, Michigan

 

[RobertT687]

You could use the DateDiff function to get the difference between your target date and the beginning of the year such as :
datediff("d","01/01/2003","03/31/2003&quot + 1 or
datediff("d","12/31/2002","03/31/2003&quot

 

[xlbo]

Chip Pearson has a formula for this on his luverrly excel site:

http://www.cpearson.com/excel/jdates.htm

Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde