Dates - Week to regulare date

[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

 

[John Spencer (MVP)]

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#))

 

[VINA]

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#))

.