Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]
Try:
weekstart([Re Date],0,6)
Try This:
Date(weekstart([Re Date])-1)
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.
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.
See this blog post: Ancient Gods and Modern Days
Try :
=WEEKDAY(Floor(WEEKDAY([Re Date])+8))