Create Monday-Friday week column for grouping.

[proctors]

Im using one of the widely available Master Calendars available for QV but what our users need is a date formatted with such as Monday dash Friday foot each week. For example,
For 2019, we would have 1/7-1/11. Can we do this in the load script?

[jonathandienst · Accepted solution]

Like this:

LOAD ...
    Date,
    Date(WeekStart(Date) + 1, 'M/DD') & '-' & Date(WeekStart(Date) + 6, 'M/DD') as Week,
    ...

[proctors]

This is great. Now, if I wanted to then create a Chart where the columns were the next 5 weeks(based off of today), how would I do that?

For example

	1/07-1/12	1/14-1/19	1/21-1/26	…
Person 1
Person 2
Person 3

[jonathandienst]

Include the set expression in the table expressions. Something like this:

Sum({<Date = {">=$(=Today()) <=$(=Today()+35)"}>} ...

[proctors]

Ok, so that gave me one column, however, I'm not sure how to make the weekly columns including the labels that you helped me create for the week. Also, what is the "35"?