How can i convert yyyyww like 200903 to date?

  • Thread starter Thread starter paul
  • Start date Start date
P

paul

In ms access 2003 i would like to convert yyyyww (e.g 200903) to first date
and end date of given week?
 
In ms access 2003 i would like to convert yyyyww (e.g 200903) to first date
and end date of given week?
Click to expand...

This depends on what your source means by the week number. Is week 01 the week
starting on January 1 (so that the starting day of the week changes from year
to year)? the week including January 1 (even if that's the Saturday at the end
of the week)? The week containing the first Wednesday of the year? or what?

You can get a "rough cut" using an expression

DateAdd("ww", Right(yourfield, 2), DateSerial(Left(yourfield, 4), 1, 1))

using DateSerial to get the January 1 date in that year and DateAdd to add
that many weeks to that date, but the answer will be incorrect if your
definition of a week number differs from the one Access assumes.
 
Back
Top