hello everyone,
I want to get first day of week and

i applied this formula for getting date range

if DayOfWeek ({@DATE})=2 then
{@DATE}
else if DayOfWeek ({@DATE})=3 then
{@DATE}-1
else if DayOfWeek ({@DATE})=4 then
{@DATE}-2
else if DayOfWeek ({@DATE})=5 then
{@DATE}-3
else  If DayOfWeek ({@DATE})=6 Then
{@DATE}-4
else If DayOfWeek ({@DATE})=7 Then
{@DATE}-5

//DayOfWeek ({@DATE})

But when the month changes this formula doesnt work..

can anyone tell me what should be the formula even when the month changes?