Posted by ZeldorBlat on 10/03/05 16:30

DAYOFYEAR() is a MySQL thing. In Access (and most T-SQL RDBMS like MS
SQL and Sybase) you would do something like this instead of
DAYOFYEAR():

datepart(y, '2005-09-01')

Check the documentation for specifics, though.

[Back to original message]