Skip to content

icon picker
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
1
7/1/2022
Friday
26
2
7/2/2022
Saturday
26
3
7/3/2022
Sunday
26
4
7/4/2022
Monday
27
5
7/5/2022
Tuesday
27
6
7/6/2022
Wednesday
27
7
7/7/2022
Thursday
27
8
7/8/2022
Friday
27
9
7/9/2022
Saturday
27
10
7/10/2022
Sunday
27
11
7/11/2022
Monday
28
12
7/12/2022
Tuesday
28
13
7/13/2022
Wednesday
28
14
7/14/2022
Thursday
28
15
7/15/2022
Friday
28
16
7/16/2022
Saturday
28
17
7/17/2022
Sunday
28
18
7/18/2022
Monday
29
19
7/19/2022
Tuesday
29
20
7/20/2022
Wednesday
29
21
7/21/2022
Thursday
29
22
7/22/2022
Friday
29
23
7/23/2022
Saturday
29
24
7/24/2022
Sunday
29
25
7/25/2022
Monday
30
26
7/26/2022
Tuesday
30
27
7/27/2022
Wednesday
30
28
7/28/2022
Thursday
30
29
7/29/2022
Friday
30
30
7/30/2022
Saturday
30
31
7/31/2022
Sunday
30
There are no rows in this table

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.