Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try below
Dual('Week of '&weekstart($1,0,0), weekstart($1,0,0)) AS [Week] Tagged ('$weeknumber', '$cyclic')
try below
Dual('Week of '&weekstart($1,0,0), weekstart($1,0,0)) AS [Week] Tagged ('$weeknumber', '$cyclic')
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.