Given what? A date, a week number?

Try this:

date() - dow(date()) + 1 && First day of week

Substitue any date value for DATE().

If given the week number, you could do something like so:

FirstDayOfYear + (WeekNum * 7) - dow(FirstDayOfYear + (WeekNum * 7)) + 1

This is rough, untested, and off the top of my head, but hopefully it will get you in the ballpark.


>Hi all.,
>Anybody has function/solution which returns date for first and last of any week in year ?
>TIA,
>Gojko