Date - Need Number For Day In Calendar Year

[Paperback Writer]

I need a query that will display what number a particular day is in the
calendar year.

Example:
January 1, 2008 = 1
February 1, 2008 = 32
March 1, 2008 = 61
April 1, 2008 = 92

I prefer this to be in the form of an expression.

Using Day([DATE FIELD]) only displays the number of days by calendar month.

THANK YOU!!

 

[Stefan Hoffmann]

hi,

I need a query that will display what number a particular day is in the
calendar year.
I prefer this to be in the form of an expression.

Use this "simple" date calculation:

[DATE FIELD] - DateSerial(Year([DATE FIELD]), 1, 1)


mfG
--> stefan <--

 

[Jerry Whittle]

DatePart("y",#March 1, 2008#)