what week number

[SAC]

How do I get the week number to return?

I've tried week(InvoiceDate) and weeknum(InvoiceDate) but they don't work.

Thanks.

 

[Allen Browne]

Try:
DatePart("ww", [InvoiceDate])

 

[Arvin Meyer]

Check the help files for the DatePart function. More specifically:

?DatePart("ww", Date())
37

Today is part of the 37th week of the year.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[SAC]

Thanks!

Try:
DatePart("ww", [InvoiceDate])

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

How do I get the week number to return?

I've tried week(InvoiceDate) and weeknum(InvoiceDate) but they don't

work.

 

[SAC]

Thanks!

Check the help files for the DatePart function. More specifically:

?DatePart("ww", Date())
37

Today is part of the 37th week of the year.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access