-
Notifications
You must be signed in to change notification settings - Fork 0
/
fxCalendarSimple.m
33 lines (31 loc) · 1.79 KB
/
fxCalendarSimple.m
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
//简单版日期表
let
date_start = #date(2022, 1, 1), //开始日期
date_end = #date(2022, 12, 31), //结束日期
count = Duration.Days(date_end - date_start), //间隔天数
calendar0 = #table(
type table
[
日期 = Date.Type, //01、日期
天 = Int64.Type, //02、日期:天
月份 = Text.Type, //14、月份M简写
年月 = Text.Type, //18、年月M简写
年 = Text.Type //29、年度FY简写
],
List.Transform(
{0 .. count},
(n) =>
let
d = Date.AddDays(date_start, n)
in
{
d, //01
Date.Day(d), //02
"M" & Date.ToText(d, "MM"), //14
Date.ToText(d, "Yyy") & "M" & Date.ToText(d, "MM"), //18
"FY" & Date.ToText(d, "yy") //29
}
)
)
in
calendar0