Date Question.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know how to make Access look up the Julian date? Julian date is
how many days there have been so far in the year. (ie: 5 Janurary 05 : 05005,
30 Janurary : 05030, 1 April 05 : 05090 and 31 December 05 : 05365) [first 2
digits are the last 2 digits of the year, and the last 3 is the number of
days that have passed.]
 
Does anyone know how to make Access look up the Julian date? Julian date is
how many days there have been so far in the year.
Click to expand...

That's one of MANY different definitions of the surprisingly ambiguous
term "Julian Date". Thanks for explaining your particular variant.
(ie: 5 Janurary 05 : 05005,
30 Janurary : 05030, 1 April 05 : 05090 and 31 December 05 : 05365) [first 2
digits are the last 2 digits of the year, and the last 3 is the number of
days that have passed.]
Click to expand...

You can display the Julian date of an Access date/time field with the
expression

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


John W. Vinson[MVP]
 
Back
Top