Variable - Display "week of..."

[jerryr125]

Hi - 

The following displays the week of the year for a given specific date :

Dual('W'&Num(Week($1),00), Num(Week($1),00)) AS [Week] Tagged ('$weeknumber', '$cyclic'),

Example :

W10

I am looking for another option to display instead of W10 to display something like :

"Week of 7/27/2020"

"Week of 8/3/2020"

Thus - the monday of the week for the specific date.

Thanks - Jerry

[Kushal_Chawda · Accepted solution]

try below

Dual('Week of '&weekstart($1,0,0), weekstart($1,0,0)) AS [Week] Tagged ('$weeknumber', '$cyclic')

[Vegar]

I believe that @Kushal_Chawda suggested solution will do the trick, but I would no longer used the $cyclic tag as the values are no longer cyclic when using start date instead of week number.