Skip to content
Example
In the button I make us of a named canvas function.
If([DB ThisMonth].Count(),DeleteRows([DB ThisMonth]),
Sequence(1,_AllDatesThisMonth.Count()).FormulaMap(
[DB ThisMonth].AddRow(
TheDate,_AllDatesThisMonth.Nth(CurrentValue),
[DB ThisMonth].WeekDayName,_AllDatesThisMonth.Nth(CurrentValue).WeekdayName(),
[DB ThisMonth].WeekNumber,_AllDatesThisMonth.Nth(CurrentValue).IsoWeekNumber()
)))
Clear Table #
Example
TheDate
WeekDayName
WeekNumber
7/1/2022
Friday
26
7/2/2022
Saturday
26
7/3/2022
Sunday
26
7/4/2022
Monday
27
7/5/2022
Tuesday
27
7/6/2022
Wednesday
27
7/7/2022
Thursday
27
7/8/2022
Friday
27
7/9/2022
Saturday
27
7/10/2022
Sunday
27
7/11/2022
Monday
28
7/12/2022
Tuesday
28
7/13/2022
Wednesday
28
7/14/2022
Thursday
28
7/15/2022
Friday
28
7/16/2022
Saturday
28
7/17/2022
Sunday
28
7/18/2022
Monday
29
7/19/2022
Tuesday
29
7/20/2022
Wednesday
29
7/21/2022
Thursday
29
7/22/2022
Friday
29
7/23/2022
Saturday
29
7/24/2022
Sunday
29
7/25/2022
Monday
30
7/26/2022
Tuesday
30
7/27/2022
Wednesday
30
7/28/2022
Thursday
30
7/29/2022
Friday
30
7/30/2022
Saturday
30
7/31/2022
Sunday
30
There are no rows in this table
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.