|
|
Posted by brett on 09/30/12 11:28
On 3 Oct 2005 06:30:33 -0700, "ZeldorBlat" <zeldorblat@gmail.com>
wrote:
>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.
Thanks for that, illl give that a go later on today
Kind regards Brett
Navigation:
[Reply to this message]
|