Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do you display a week ending date instead of the week number?
Maybe like
Weekend(DATEFIELD)
or
DayName(Weekend(DATEFIELD))
what about weekyear? I am thinking go into data load editor changing the SET FirstWeekDay=6; to a 5 because first weekday is Sunday then using an expression of weekyear then format column to display MMM-DD?
Weekyear() returns the year to which the week number belongs.
Where do you want to use it?
If you want to change the week numbering have a look at