How to get first day of week N?

swj

Hello Experts,

I tried to search but not get exactly what i need. Hope can give advice.

I want to get first day of week N (N is between 1-51)
example: first day of week 1 is 03/01/2011
first day of week 4 is 24/01/2011

Using DATE2DWY, I just get the week N.

THANKS in advance

einsTeIn.NET

There is a function the other way round. Take a look at DWY2DATE.

Or you could use

CALCDATE('<-CW>',YourDate);

crisnicolas

You can youse table 2000000007 Date.
Period Type: Week
Period No.: the number of week
Some additional filtering to get the week of the year you are interested in.
Field Period Start is what you want.