topic Re: Variable - Display "week of..." in App Development

Variable - Display "week of..."

jerryr125 — Sat, 16 Nov 2024 01:47:47 GMT

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

Re: Variable - Display "week of..."

Kushal_Chawda — Mon, 27 Jul 2020 23:24:37 GMT

try below

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

Re: Variable - Display "week of..."

Vegar — Tue, 28 Jul 2020 05:40:15 GMT

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.