Dates - Week to regulare date

  • Thread starter Thread starter Vina
  • Start date Start date
V

Vina

I have a column in my query that has the number for the
week of the year. Can someone give me an idea on how i
can convert this to a regular date meaning maybe give me
the first day of the week?

Thanks
Vina
 
Try the DateAdd function.

TheDate: DateAdd("ww",WeekCount - 1,#1/1/04#)

That should give you a date in the week. If you want the first day of the week
then you will have to manipulate this a bit more

TheDate: DateAdd("d",1-Weekday(DateAdd("ww",WeekCount -
1,#1/1/04#)),DateAdd("ww",WeekCount - 1,#1/1/04#))
 
Thanks John, this works great!!!
-----Original Message-----
Try the DateAdd function.

TheDate: DateAdd("ww",WeekCount - 1,#1/1/04#)

That should give you a date in the week. If you want the first day of the week
then you will have to manipulate this a bit more

TheDate: DateAdd("d",1-Weekday(DateAdd("ww",WeekCount -
1,#1/1/04#)),DateAdd("ww",WeekCount - 1,#1/1/04#))

.
Click to expand...
 
Back
Top