Weekstart change to Sunday

[#1]

Hi,

I would like to change the weekstart to Sunday. I tried to change  weekstart([Re Date],0,-1) but it doesnt work. Below is my sceipt.

Please help!

if( month(weekstart([Re Date]))= month([Re Date]),weekstart([Re Date]),
if(weekday(makedate(Year ([Re Date]),month([Re Date]),1))=5,makedate(Year ([Re Date]),month([Re Date]),3),
if(weekday(makedate(Year ([Re Date]),month([Re Date]),1))=6,makedate(Year ([Re Date]),month([Re Date]),2),makedate(Year ([Re Date]),month([Re Date]),1))))
& ' to ' &
if( month(weekend([Re Date]))= month([Re Date]),makedate(year([Re Date]),month([Re Date]),day (weekend([Re Date]))-2),
if(weekday(monthend([Re Date]))=5,makedate(Year ([Re Date]),month([Re Date]),day(monthend([Re Date]))-1),
if(weekday(monthend([Re Date]))=6,makedate(Year ([Re Date]),month([Re Date]),day(monthend([Re Date]))-2),monthend([Re Date])))) as [App weekperiod],
if(week(makedate(year([Re Date]), month([Re Date]),1))>week([Re Date]),
week(makedate(year([Re Date]), month([Re Date]),1))+
week([Re Date])- week(makedate(year([Re Date]), month([Re Date]),1))+1,
week([Re Date])- week(makedate(year([Re Date]), month([Re Date]),1))+1) as [App week]

[tresesco]

Try:

weekstart([Re Date],0,6)

[orital81]

Try This:

Date(weekstart([Re Date])-1)

[#4]

still not working...
if( month(weekstart([Re Date],0,6))= month([Re Date]),weekstart([Re Date],0,6)

If there is any other areas that I need to amend.

[#5]

still not working...
if( month(weekstart([Re Date]-1))= month([Re Date]),weekstart([Re Date]-1)

If there is any other areas that I need to amend.

[Gysbert_Wassenaar]

See this blog post: Ancient Gods and Modern Days

[#7]

Try :

=WEEKDAY(Floor(WEEKDAY([Re Date])+8))