I want julian dates in my calendar

[Guest]

We use julian dates in our programing and need the the day of the year to
access.

 

[Douglas J. Steele]

You can convert a date to day of the year using either DatePart("y", Date())
or Format(Date(), "y")

The first one returns a number, the second returns a string.

 

[John Vinson]

We use julian dates in our programing and need the the day of the year to
access.

DatePart("y", [datefield])

will return a number 1-366 for the day of the year.

Format([datefield], "yyyy") & Format(DatePart("y", [datefield]),
"000")

will return 2005120 for the 120th day of the year.

John W. Vinson[MVP]