Get day of year

[mlh407]

Hi all, is there a way in access to get the day number of the year.

so 1-1-05 would be day #1 and 12-31-05 = 365

Is there a way to do this?


Michael

 

[ghudson]

Check the Access help files for the DateDiff() function.

 

[Noljt]

One Solution

Here is a function that will return the day of the year. You use it this way:

DayOfYear(#7/1/2005#) which returns 182


Function DayOfYear(DateToUse As Date)
'Computes the Consecutive Day for a year with Jan 1st = day 1,
' Feb 1st = day 32 etc

DayOfYear = DateDiff("d", "1/1/" & Format(DateToUse, "yyyy"), DateToUse) + 1

End Function

 

[raskew]

Datepart() function:

mydate = date()
? mydate
11/15/05
? datepart("y", mydate)
319

Bob

 

[majsparky]

Michael,

You should be able to use a Date\Time Format:

Format([yourDate],"y")