Display weekending January 9 instead of week 2

[#1]

How do you display a week ending date instead of the week number?

[swuehl · Accepted solution]

Maybe like

Weekend(DATEFIELD)

or

DayName(Weekend(DATEFIELD))

[swuehl]

Or if you don't have a DATEFIELD:

MakeWeekDate(2016, Subfield(WeekNoField,' ',2), 6)

See the help for:

MakeWeekDate(YYYY [ , WW [ , D ] ] )

[#4]

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?

[swuehl]

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

Redefining the Week Start in Qlik Sense