# of days since Jan. 1

[mate]

i want to use the number of days since Jan. 1 first in an
equation. Is there an expression to calculate this? any
help is greatly appreciated. Thankyou.

mate.

 

[Rick B]

DaysPast: Date()-#01/01/04#


Will tell you the number of days between today and Jan 1.

Rick B



i want to use the number of days since Jan. 1 first in an
equation. Is there an expression to calculate this? any
help is greatly appreciated. Thankyou.

mate.

 

[John Spencer (MVP)]

For the current date of the current year, you can use the formula below.

DateDiff("d",DateSerial(Year(Date()),1,1),Date())

 

[John Vinson]

i want to use the number of days since Jan. 1 first in an
equation. Is there an expression to calculate this? any
help is greatly appreciated. Thankyou.

mate.

One question, several solutions: yet another is

Format(Date(), "y")