Date - Need Number For Day In Calendar Year

  • Thread starter Thread starter Paperback Writer
  • Start date Start date
P

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!!
 
hi,

Paperback said:
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.
Click to expand...
Use this "simple" date calculation:

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


mfG
--> stefan <--
 
Back
Top