Week of the Year, Starting with the 1st Sunday (?)

  • Thread starter Thread starter tbl
  • Start date Start date
T

tbl

Is there a relatively easy way to get Access (2000) to
calculate the week of the year where the first week is the
first *full* week (USA--weeks starting on Sunday)?
 
Hi tbl

Try this:

DatePart( "ww", [YourDate], vbSunday, vbFirstFullWeek )

If you are doing this in a query or calculated control, the vbXXX constants
won't work. Instead use:
1 (vbSunday)
3 (vbFirstFullWeek)
 
Hi tbl

Try this:

DatePart( "ww", [YourDate], vbSunday, vbFirstFullWeek )

If you are doing this in a query or calculated control, the vbXXX constants
won't work. Instead use:
1 (vbSunday)
3 (vbFirstFullWeek)
Click to expand...



Thanks Graham! I'll definitely give those a shot. As soon
as I can get by eyes to focus again...
 
Back
Top