Need to know a date 1

[Elsje]

Hello,

I have a weeknumber for example week 51 and I need to know a date in this week for example 19/12/2007. It can be any date in this week.

Is there an easy way to do something like this.

Thanks in advance
Els

 

[DickDavies]

Try :

DayNo = (Week -1) * 7
Date = DateAdd("d", DayNo,#1/1/2007#)

Should give you date of the first day in that week.