Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I was able to omit the current week in a rolling 13 weeks average without employing a master calendar script, So, I'm hoping there's a way to force Sunday to be the starting day of the week. I'm just not sure what search criteria would be used or what expression syntax is needed. Any ideas?
Try
"Week(Weekstart(TempDate,0,-1))"
Where TempDate is your date field.
Regards
RL
Try
"Week(Weekstart(TempDate,0,-1))"
Where TempDate is your date field.
Regards
RL
If you have a Date from which you are arriving at the week number, use Week(Date+1) or WeekName(Date+1) to get the week number, to start your week on Sundays.
Hope this helps.
Perfect, lakhina - the chart dimension that worked was
=date(WeekStart(dev_finish_date,0,-1),'MMM-D')
Thank you!