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.

• Next in forum: sorting two result sets by common type field
• Prev in forum: Re: getting REGEXP query
• Thread view: Re: Birthday SQL Problem

[Reply to this message]