what week number

SAC · Sep 10, 2004

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 · Sep 10, 2004

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

Arvin Meyer · Sep 10, 2004

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 · Sep 10, 2004

Thanks!

Allen Browne said:
Try:
DatePart("ww", [InvoiceDate])

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

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

SAC said:

How do I get the week number to return?

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

Click to expand...

work.

SAC · Sep 10, 2004

Thanks!

Arvin Meyer said:
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