J
John Lane
Is there an easy way to get all the dates for all the Mondays, Tuesdays, etc.
for a given year? Thanks.
for a given year? Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Alicia
Between Date() and Date()-6
J
John Lane
I must be incredibily stupid. What I really meant was how do I get which week
of the year a day is in for a given year?
of the year a day is in for a given year?
S
Steve.C.Hutchinson
I must be incredibily stupid. What I really meant was how do I get which week
of the year a day is in for a given year?
- Show quoted text -
John,
Try this on the Field line in your query:
WkNumber: DatePart("ww",[YourDate])
I recommend the books Microsoft Office Access 2007 Bible and Access
2007 VBA Bible...
J
John W. Vinson
I must be incredibily stupid. What I really meant was how do I get which week
of the year a day is in for a given year?
DatePart("ww", [datefield])
Check the VBA help for Datepart; there are various ways of determining which
is the first week of the year (the week containing January 1 even if that's
Saturday at the end of the week, the week containing the first Tuesday, etc.)