struct
LY
struct
FISCALENDDATE {ts '2025-06-30 23:59:59'}
FISCALSTARTDATE {ts '2024-07-01 00:00:00'}
FISCALYEAR 2025
H1
struct
CALENDARMONTH 7,8,9,10,11,12
ENDDATE {ts '2024-12-31 23:59:59'}
ENDWEEK 26
NAME First Half 2025
PERIOD 1,2,3,4,5,6
STARTDATE {ts '2024-07-01 00:00:00'}
STARTWEEK 1
WEEKS 26
WEEKSELAPSED 26
WEEKSREMAINING 26
H2
struct
CALENDARMONTH 1,2,3,4,5,6
ENDDATE {ts '2025-06-30 23:59:59'}
ENDWEEK 52
NAME Second Half 2025
PERIOD 7,8,9,10,11,12
STARTDATE {ts '2025-01-01 00:00:00'}
STARTWEEK 27
WEEKS 26
WEEKSELAPSED 52
WEEKSREMAINING 0
MONTHS
array
1
struct
CALENDARMONTH 1
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-01-31 23:59:59'}
ENDWEEK 30
NAME January 2025
PERIOD 7
QUARTER 3
STARTDATE {ts '2025-01-01 00:00:00'}
STARTWEEK 27
WEEKS 4
WEEKSELAPSED 30
WEEKSREMAINING 22
2
struct
CALENDARMONTH 2
CALENDARYEAR 2025
DAYSINPERIOD 28
ENDDATE {ts '2025-02-28 23:59:59'}
ENDWEEK 34
NAME February 2025
PERIOD 8
QUARTER 3
STARTDATE {ts '2025-02-01 00:00:00'}
STARTWEEK 31
WEEKS 4
WEEKSELAPSED 34
WEEKSREMAINING 18
3
struct
CALENDARMONTH 3
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-03-31 23:59:59'}
ENDWEEK 39
NAME March 2025
PERIOD 9
QUARTER 3
STARTDATE {ts '2025-03-01 00:00:00'}
STARTWEEK 35
WEEKS 5
WEEKSELAPSED 39
WEEKSREMAINING 13
4
struct
CALENDARMONTH 4
CALENDARYEAR 2025
DAYSINPERIOD 30
ENDDATE {ts '2025-04-30 23:59:59'}
ENDWEEK 43
NAME April 2025
PERIOD 10
QUARTER 4
STARTDATE {ts '2025-04-01 00:00:00'}
STARTWEEK 40
WEEKS 4
WEEKSELAPSED 43
WEEKSREMAINING 9
5
struct
CALENDARMONTH 5
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-05-31 23:59:59'}
ENDWEEK 47
NAME May 2025
PERIOD 11
QUARTER 4
STARTDATE {ts '2025-05-01 00:00:00'}
STARTWEEK 44
WEEKS 4
WEEKSELAPSED 47
WEEKSREMAINING 5
6
struct
CALENDARMONTH 6
CALENDARYEAR 2025
DAYSINPERIOD 30
ENDDATE {ts '2025-06-30 23:59:59'}
ENDWEEK 52
NAME June 2025
PERIOD 12
QUARTER 4
STARTDATE {ts '2025-06-01 00:00:00'}
STARTWEEK 48
WEEKS 5
WEEKSELAPSED 52
WEEKSREMAINING 0
7
struct
CALENDARMONTH 7
CALENDARYEAR 2024
DAYSINPERIOD 31
ENDDATE {ts '2024-07-31 23:59:59'}
ENDWEEK 4
NAME July 2024
PERIOD 1
QUARTER 1
STARTDATE {ts '2024-07-01 00:00:00'}
STARTWEEK 1
WEEKS 4
WEEKSELAPSED 4
WEEKSREMAINING 48
8
struct
CALENDARMONTH 8
CALENDARYEAR 2024
DAYSINPERIOD 31
ENDDATE {ts '2024-08-31 23:59:59'}
ENDWEEK 8
NAME August 2024
PERIOD 2
QUARTER 1
STARTDATE {ts '2024-08-01 00:00:00'}
STARTWEEK 5
WEEKS 4
WEEKSELAPSED 8
WEEKSREMAINING 44
9
struct
CALENDARMONTH 9
CALENDARYEAR 2024
DAYSINPERIOD 30
ENDDATE {ts '2024-09-30 23:59:59'}
ENDWEEK 13
NAME September 2024
PERIOD 3
QUARTER 1
STARTDATE {ts '2024-09-01 00:00:00'}
STARTWEEK 9
WEEKS 5
WEEKSELAPSED 13
WEEKSREMAINING 39
10
struct
CALENDARMONTH 10
CALENDARYEAR 2024
DAYSINPERIOD 31
ENDDATE {ts '2024-10-31 23:59:59'}
ENDWEEK 17
NAME October 2024
PERIOD 4
QUARTER 2
STARTDATE {ts '2024-10-01 00:00:00'}
STARTWEEK 14
WEEKS 4
WEEKSELAPSED 17
WEEKSREMAINING 35
11
struct
CALENDARMONTH 11
CALENDARYEAR 2024
DAYSINPERIOD 30
ENDDATE {ts '2024-11-30 23:59:59'}
ENDWEEK 21
NAME November 2024
PERIOD 5
QUARTER 2
STARTDATE {ts '2024-11-01 00:00:00'}
STARTWEEK 18
WEEKS 4
WEEKSELAPSED 21
WEEKSREMAINING 31
12
struct
CALENDARMONTH 12
CALENDARYEAR 2024
DAYSINPERIOD 31
ENDDATE {ts '2024-12-31 23:59:59'}
ENDWEEK 26
NAME December 2024
PERIOD 6
QUARTER 2
STARTDATE {ts '2024-12-01 00:00:00'}
STARTWEEK 22
WEEKS 5
WEEKSELAPSED 26
WEEKSREMAINING 26
PERIODS
array
1
struct
CALENDARMONTH 7
CALENDARYEAR 2024
DAYSINPERIOD 31
ENDDATE {ts '2024-07-31 23:59:59'}
ENDWEEK 4
NAME July 2024
PERIOD 1
QUARTER 1
STARTDATE {ts '2024-07-01 00:00:00'}
STARTWEEK 1
WEEKS 4
WEEKSELAPSED 4
WEEKSREMAINING 48
2
struct
CALENDARMONTH 8
CALENDARYEAR 2024
DAYSINPERIOD 31
ENDDATE {ts '2024-08-31 23:59:59'}
ENDWEEK 8
NAME August 2024
PERIOD 2
QUARTER 1
STARTDATE {ts '2024-08-01 00:00:00'}
STARTWEEK 5
WEEKS 4
WEEKSELAPSED 8
WEEKSREMAINING 44
3
struct
CALENDARMONTH 9
CALENDARYEAR 2024
DAYSINPERIOD 30
ENDDATE {ts '2024-09-30 23:59:59'}
ENDWEEK 13
NAME September 2024
PERIOD 3
QUARTER 1
STARTDATE {ts '2024-09-01 00:00:00'}
STARTWEEK 9
WEEKS 5
WEEKSELAPSED 13
WEEKSREMAINING 39
4
struct
CALENDARMONTH 10
CALENDARYEAR 2024
DAYSINPERIOD 31
ENDDATE {ts '2024-10-31 23:59:59'}
ENDWEEK 17
NAME October 2024
PERIOD 4
QUARTER 2
STARTDATE {ts '2024-10-01 00:00:00'}
STARTWEEK 14
WEEKS 4
WEEKSELAPSED 17
WEEKSREMAINING 35
5
struct
CALENDARMONTH 11
CALENDARYEAR 2024
DAYSINPERIOD 30
ENDDATE {ts '2024-11-30 23:59:59'}
ENDWEEK 21
NAME November 2024
PERIOD 5
QUARTER 2
STARTDATE {ts '2024-11-01 00:00:00'}
STARTWEEK 18
WEEKS 4
WEEKSELAPSED 21
WEEKSREMAINING 31
6
struct
CALENDARMONTH 12
CALENDARYEAR 2024
DAYSINPERIOD 31
ENDDATE {ts '2024-12-31 23:59:59'}
ENDWEEK 26
NAME December 2024
PERIOD 6
QUARTER 2
STARTDATE {ts '2024-12-01 00:00:00'}
STARTWEEK 22
WEEKS 5
WEEKSELAPSED 26
WEEKSREMAINING 26
7
struct
CALENDARMONTH 1
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-01-31 23:59:59'}
ENDWEEK 30
NAME January 2025
PERIOD 7
QUARTER 3
STARTDATE {ts '2025-01-01 00:00:00'}
STARTWEEK 27
WEEKS 4
WEEKSELAPSED 30
WEEKSREMAINING 22
8
struct
CALENDARMONTH 2
CALENDARYEAR 2025
DAYSINPERIOD 28
ENDDATE {ts '2025-02-28 23:59:59'}
ENDWEEK 34
NAME February 2025
PERIOD 8
QUARTER 3
STARTDATE {ts '2025-02-01 00:00:00'}
STARTWEEK 31
WEEKS 4
WEEKSELAPSED 34
WEEKSREMAINING 18
9
struct
CALENDARMONTH 3
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-03-31 23:59:59'}
ENDWEEK 39
NAME March 2025
PERIOD 9
QUARTER 3
STARTDATE {ts '2025-03-01 00:00:00'}
STARTWEEK 35
WEEKS 5
WEEKSELAPSED 39
WEEKSREMAINING 13
10
struct
CALENDARMONTH 4
CALENDARYEAR 2025
DAYSINPERIOD 30
ENDDATE {ts '2025-04-30 23:59:59'}
ENDWEEK 43
NAME April 2025
PERIOD 10
QUARTER 4
STARTDATE {ts '2025-04-01 00:00:00'}
STARTWEEK 40
WEEKS 4
WEEKSELAPSED 43
WEEKSREMAINING 9
11
struct
CALENDARMONTH 5
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-05-31 23:59:59'}
ENDWEEK 47
NAME May 2025
PERIOD 11
QUARTER 4
STARTDATE {ts '2025-05-01 00:00:00'}
STARTWEEK 44
WEEKS 4
WEEKSELAPSED 47
WEEKSREMAINING 5
12
struct
CALENDARMONTH 6
CALENDARYEAR 2025
DAYSINPERIOD 30
ENDDATE {ts '2025-06-30 23:59:59'}
ENDWEEK 52
NAME June 2025
PERIOD 12
QUARTER 4
STARTDATE {ts '2025-06-01 00:00:00'}
STARTWEEK 48
WEEKS 5
WEEKSELAPSED 52
WEEKSREMAINING 0
Q1
struct
CALENDARMONTH 7,8,9
ENDDATE {ts '2024-09-30 23:59:59'}
ENDWEEK 13
NAME Q1 2025
PERIOD 1,2,3
QUARTER 1
STARTDATE {ts '2024-07-01 00:00:00'}
STARTWEEK 1
WEEKS 13
WEEKSELAPSED 13
WEEKSREMAINING 39
Q2
struct
CALENDARMONTH 10,11,12
ENDDATE {ts '2024-12-31 23:59:59'}
ENDWEEK 26
NAME Q2 2025
PERIOD 4,5,6
QUARTER 2
STARTDATE {ts '2024-10-01 00:00:00'}
STARTWEEK 14
WEEKS 13
WEEKSELAPSED 26
WEEKSREMAINING 26
Q3
struct
CALENDARMONTH 1,2,3
ENDDATE {ts '2025-03-31 23:59:59'}
ENDWEEK 39
NAME Q3 2025
PERIOD 7,8,9
QUARTER 3
STARTDATE {ts '2025-01-01 00:00:00'}
STARTWEEK 27
WEEKS 13
WEEKSELAPSED 39
WEEKSREMAINING 13
Q4
struct
CALENDARMONTH 4,5,6
ENDDATE {ts '2025-06-30 23:59:59'}
ENDWEEK 52
NAME Q4 2025
PERIOD 10,11,12
QUARTER 4
STARTDATE {ts '2025-04-01 00:00:00'}
STARTWEEK 40
WEEKS 13
WEEKSELAPSED 52
WEEKSREMAINING 0
T1
struct
CALENDARMONTH 7,8,9,10
ENDDATE {ts '2024-10-31 23:59:59'}
ENDWEEK 17
NAME First Trimester 2025
PERIOD 1,2,3,4
STARTDATE {ts '2024-07-01 00:00:00'}
STARTWEEK 1
WEEKS 17
WEEKSELAPSED 17
WEEKSREMAINING 35
T2
struct
CALENDARMONTH 11,12,1,2
ENDDATE {ts '2025-02-28 23:59:59'}
ENDWEEK 34
NAME Second Trimester 2025
PERIOD 5,6,7,8
STARTDATE {ts '2024-11-01 00:00:00'}
STARTWEEK 18
WEEKS 17
WEEKSELAPSED 34
WEEKSREMAINING 18
T3
struct
CALENDARMONTH 3,4,5,6
ENDDATE {ts '2025-06-30 23:59:59'}
ENDWEEK 52
NAME Third Trimester 2025
PERIOD 9,10,11,12
STARTDATE {ts '2025-03-01 00:00:00'}
STARTWEEK 35
WEEKS 18
WEEKSELAPSED 52
WEEKSREMAINING 0
TOTALWEEKS 52
WEEKS
array
1
struct
CALENDARMONTH 7
CALENDARYEAR 2024
DAYSINPERIOD 31
ENDDATE {ts '2024-07-06 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 1
PERIOD 1
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 1
STARTDATE {ts '2024-07-01 00:00:00'}
WEEKS 4
WEEKSELAPSED 1
WEEKSREMAINING 51
2
struct
CALENDARMONTH 7
CALENDARYEAR 2024
DAYSINPERIOD 31
ENDDATE {ts '2024-07-13 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 2
PERIOD 1
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 2
STARTDATE {ts '2024-07-07 00:00:00'}
WEEKS 4
WEEKSELAPSED 2
WEEKSREMAINING 50
3
struct
CALENDARMONTH 7
CALENDARYEAR 2024
DAYSINPERIOD 31
ENDDATE {ts '2024-07-20 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 3
PERIOD 1
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 3
STARTDATE {ts '2024-07-14 00:00:00'}
WEEKS 4
WEEKSELAPSED 3
WEEKSREMAINING 49
4
struct
CALENDARMONTH 7
CALENDARYEAR 2024
DAYSINPERIOD 31
ENDDATE {ts '2024-07-27 23:59:59'}
MONTHEND true
NAME Fiscal 2025 Week 4
PERIOD 1
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 4
STARTDATE {ts '2024-07-21 00:00:00'}
WEEKS 4
WEEKSELAPSED 4
WEEKSREMAINING 48
5
struct
CALENDARMONTH 7
CALENDARYEAR 2024
DAYSINPERIOD 31
ENDDATE {ts '2024-08-03 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 5
PERIOD 1
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 5
STARTDATE {ts '2024-07-28 00:00:00'}
WEEKS 4
WEEKSELAPSED 5
WEEKSREMAINING 47
6
struct
CALENDARMONTH 8
CALENDARYEAR 2024
DAYSINPERIOD 31
ENDDATE {ts '2024-08-10 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 6
PERIOD 2
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 6
STARTDATE {ts '2024-08-04 00:00:00'}
WEEKS 4
WEEKSELAPSED 6
WEEKSREMAINING 46
7
struct
CALENDARMONTH 8
CALENDARYEAR 2024
DAYSINPERIOD 31
ENDDATE {ts '2024-08-17 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 7
PERIOD 2
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 7
STARTDATE {ts '2024-08-11 00:00:00'}
WEEKS 4
WEEKSELAPSED 7
WEEKSREMAINING 45
8
struct
CALENDARMONTH 8
CALENDARYEAR 2024
DAYSINPERIOD 31
ENDDATE {ts '2024-08-24 23:59:59'}
MONTHEND true
NAME Fiscal 2025 Week 8
PERIOD 2
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 8
STARTDATE {ts '2024-08-18 00:00:00'}
WEEKS 4
WEEKSELAPSED 8
WEEKSREMAINING 44
9
struct
CALENDARMONTH 8
CALENDARYEAR 2024
DAYSINPERIOD 31
ENDDATE {ts '2024-08-31 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 9
PERIOD 2
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 9
STARTDATE {ts '2024-08-25 00:00:00'}
WEEKS 4
WEEKSELAPSED 9
WEEKSREMAINING 43
10
struct
CALENDARMONTH 9
CALENDARYEAR 2024
DAYSINPERIOD 30
ENDDATE {ts '2024-09-07 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 10
PERIOD 3
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 10
STARTDATE {ts '2024-09-01 00:00:00'}
WEEKS 5
WEEKSELAPSED 10
WEEKSREMAINING 42
11
struct
CALENDARMONTH 9
CALENDARYEAR 2024
DAYSINPERIOD 30
ENDDATE {ts '2024-09-14 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 11
PERIOD 3
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 11
STARTDATE {ts '2024-09-08 00:00:00'}
WEEKS 5
WEEKSELAPSED 11
WEEKSREMAINING 41
12
struct
CALENDARMONTH 9
CALENDARYEAR 2024
DAYSINPERIOD 30
ENDDATE {ts '2024-09-21 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 12
PERIOD 3
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 12
STARTDATE {ts '2024-09-15 00:00:00'}
WEEKS 5
WEEKSELAPSED 12
WEEKSREMAINING 40
13
struct
CALENDARMONTH 9
CALENDARYEAR 2024
DAYSINPERIOD 30
ENDDATE {ts '2024-09-28 23:59:59'}
MONTHEND true
NAME Fiscal 2025 Week 13
PERIOD 3
QUARTER Q1
QUARTEREND true
QUARTERWEEKSELAPSED 13
STARTDATE {ts '2024-09-22 00:00:00'}
WEEKS 5
WEEKSELAPSED 13
WEEKSREMAINING 39
14
struct
CALENDARMONTH 9
CALENDARYEAR 2024
DAYSINPERIOD 30
ENDDATE {ts '2024-10-05 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 14
PERIOD 3
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 14
STARTDATE {ts '2024-09-29 00:00:00'}
WEEKS 5
WEEKSELAPSED 14
WEEKSREMAINING 38
15
struct
CALENDARMONTH 10
CALENDARYEAR 2024
DAYSINPERIOD 31
ENDDATE {ts '2024-10-12 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 15
PERIOD 4
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 2
STARTDATE {ts '2024-10-06 00:00:00'}
WEEKS 4
WEEKSELAPSED 15
WEEKSREMAINING 37
16
struct
CALENDARMONTH 10
CALENDARYEAR 2024
DAYSINPERIOD 31
ENDDATE {ts '2024-10-19 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 16
PERIOD 4
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 3
STARTDATE {ts '2024-10-13 00:00:00'}
WEEKS 4
WEEKSELAPSED 16
WEEKSREMAINING 36
17
struct
CALENDARMONTH 10
CALENDARYEAR 2024
DAYSINPERIOD 31
ENDDATE {ts '2024-10-26 23:59:59'}
MONTHEND true
NAME Fiscal 2025 Week 17
PERIOD 4
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 4
STARTDATE {ts '2024-10-20 00:00:00'}
WEEKS 4
WEEKSELAPSED 17
WEEKSREMAINING 35
18
struct
CALENDARMONTH 10
CALENDARYEAR 2024
DAYSINPERIOD 31
ENDDATE {ts '2024-11-02 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 18
PERIOD 4
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 5
STARTDATE {ts '2024-10-27 00:00:00'}
WEEKS 4
WEEKSELAPSED 18
WEEKSREMAINING 34
19
struct
CALENDARMONTH 11
CALENDARYEAR 2024
DAYSINPERIOD 30
ENDDATE {ts '2024-11-09 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 19
PERIOD 5
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 6
STARTDATE {ts '2024-11-03 00:00:00'}
WEEKS 4
WEEKSELAPSED 19
WEEKSREMAINING 33
20
struct
CALENDARMONTH 11
CALENDARYEAR 2024
DAYSINPERIOD 30
ENDDATE {ts '2024-11-16 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 20
PERIOD 5
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 7
STARTDATE {ts '2024-11-10 00:00:00'}
WEEKS 4
WEEKSELAPSED 20
WEEKSREMAINING 32
21
struct
CALENDARMONTH 11
CALENDARYEAR 2024
DAYSINPERIOD 30
ENDDATE {ts '2024-11-23 23:59:59'}
MONTHEND true
NAME Fiscal 2025 Week 21
PERIOD 5
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 8
STARTDATE {ts '2024-11-17 00:00:00'}
WEEKS 4
WEEKSELAPSED 21
WEEKSREMAINING 31
22
struct
CALENDARMONTH 11
CALENDARYEAR 2024
DAYSINPERIOD 30
ENDDATE {ts '2024-11-30 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 22
PERIOD 5
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 9
STARTDATE {ts '2024-11-24 00:00:00'}
WEEKS 4
WEEKSELAPSED 22
WEEKSREMAINING 30
23
struct
CALENDARMONTH 12
CALENDARYEAR 2024
DAYSINPERIOD 31
ENDDATE {ts '2024-12-07 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 23
PERIOD 6
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 10
STARTDATE {ts '2024-12-01 00:00:00'}
WEEKS 5
WEEKSELAPSED 23
WEEKSREMAINING 29
24
struct
CALENDARMONTH 12
CALENDARYEAR 2024
DAYSINPERIOD 31
ENDDATE {ts '2024-12-14 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 24
PERIOD 6
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 11
STARTDATE {ts '2024-12-08 00:00:00'}
WEEKS 5
WEEKSELAPSED 24
WEEKSREMAINING 28
25
struct
CALENDARMONTH 12
CALENDARYEAR 2024
DAYSINPERIOD 31
ENDDATE {ts '2024-12-21 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 25
PERIOD 6
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 12
STARTDATE {ts '2024-12-15 00:00:00'}
WEEKS 5
WEEKSELAPSED 25
WEEKSREMAINING 27
26
struct
CALENDARMONTH 12
CALENDARYEAR 2024
DAYSINPERIOD 31
ENDDATE {ts '2024-12-28 23:59:59'}
MONTHEND true
NAME Fiscal 2025 Week 26
PERIOD 6
QUARTER Q2
QUARTEREND true
QUARTERWEEKSELAPSED 13
STARTDATE {ts '2024-12-22 00:00:00'}
WEEKS 5
WEEKSELAPSED 26
WEEKSREMAINING 26
27
struct
CALENDARMONTH 12
CALENDARYEAR 2024
DAYSINPERIOD 31
ENDDATE {ts '2025-01-04 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 27
PERIOD 6
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 14
STARTDATE {ts '2024-12-29 00:00:00'}
WEEKS 5
WEEKSELAPSED 27
WEEKSREMAINING 25
28
struct
CALENDARMONTH 1
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-01-11 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 28
PERIOD 7
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 2
STARTDATE {ts '2025-01-05 00:00:00'}
WEEKS 4
WEEKSELAPSED 28
WEEKSREMAINING 24
29
struct
CALENDARMONTH 1
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-01-18 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 29
PERIOD 7
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 3
STARTDATE {ts '2025-01-12 00:00:00'}
WEEKS 4
WEEKSELAPSED 29
WEEKSREMAINING 23
30
struct
CALENDARMONTH 1
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-01-25 23:59:59'}
MONTHEND true
NAME Fiscal 2025 Week 30
PERIOD 7
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 4
STARTDATE {ts '2025-01-19 00:00:00'}
WEEKS 4
WEEKSELAPSED 30
WEEKSREMAINING 22
31
struct
CALENDARMONTH 1
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-02-01 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 31
PERIOD 7
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 5
STARTDATE {ts '2025-01-26 00:00:00'}
WEEKS 4
WEEKSELAPSED 31
WEEKSREMAINING 21
32
struct
CALENDARMONTH 2
CALENDARYEAR 2025
DAYSINPERIOD 28
ENDDATE {ts '2025-02-08 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 32
PERIOD 8
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 6
STARTDATE {ts '2025-02-02 00:00:00'}
WEEKS 4
WEEKSELAPSED 32
WEEKSREMAINING 20
33
struct
CALENDARMONTH 2
CALENDARYEAR 2025
DAYSINPERIOD 28
ENDDATE {ts '2025-02-15 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 33
PERIOD 8
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 7
STARTDATE {ts '2025-02-09 00:00:00'}
WEEKS 4
WEEKSELAPSED 33
WEEKSREMAINING 19
34
struct
CALENDARMONTH 2
CALENDARYEAR 2025
DAYSINPERIOD 28
ENDDATE {ts '2025-02-22 23:59:59'}
MONTHEND true
NAME Fiscal 2025 Week 34
PERIOD 8
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 8
STARTDATE {ts '2025-02-16 00:00:00'}
WEEKS 4
WEEKSELAPSED 34
WEEKSREMAINING 18
35
struct
CALENDARMONTH 2
CALENDARYEAR 2025
DAYSINPERIOD 28
ENDDATE {ts '2025-03-01 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 35
PERIOD 8
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 9
STARTDATE {ts '2025-02-23 00:00:00'}
WEEKS 4
WEEKSELAPSED 35
WEEKSREMAINING 17
36
struct
CALENDARMONTH 3
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-03-08 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 36
PERIOD 9
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 10
STARTDATE {ts '2025-03-02 00:00:00'}
WEEKS 5
WEEKSELAPSED 36
WEEKSREMAINING 16
37
struct
CALENDARMONTH 3
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-03-15 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 37
PERIOD 9
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 11
STARTDATE {ts '2025-03-09 00:00:00'}
WEEKS 5
WEEKSELAPSED 37
WEEKSREMAINING 15
38
struct
CALENDARMONTH 3
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-03-22 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 38
PERIOD 9
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 12
STARTDATE {ts '2025-03-16 00:00:00'}
WEEKS 5
WEEKSELAPSED 38
WEEKSREMAINING 14
39
struct
CALENDARMONTH 3
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-03-29 23:59:59'}
MONTHEND true
NAME Fiscal 2025 Week 39
PERIOD 9
QUARTER Q3
QUARTEREND true
QUARTERWEEKSELAPSED 13
STARTDATE {ts '2025-03-23 00:00:00'}
WEEKS 5
WEEKSELAPSED 39
WEEKSREMAINING 13
40
struct
CALENDARMONTH 3
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-04-05 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 40
PERIOD 9
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 14
STARTDATE {ts '2025-03-30 00:00:00'}
WEEKS 5
WEEKSELAPSED 40
WEEKSREMAINING 12
41
struct
CALENDARMONTH 4
CALENDARYEAR 2025
DAYSINPERIOD 30
ENDDATE {ts '2025-04-12 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 41
PERIOD 10
QUARTER Q4
QUARTEREND false
QUARTERWEEKSELAPSED 2
STARTDATE {ts '2025-04-06 00:00:00'}
WEEKS 4
WEEKSELAPSED 41
WEEKSREMAINING 11
42
struct
CALENDARMONTH 4
CALENDARYEAR 2025
DAYSINPERIOD 30
ENDDATE {ts '2025-04-19 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 42
PERIOD 10
QUARTER Q4
QUARTEREND false
QUARTERWEEKSELAPSED 3
STARTDATE {ts '2025-04-13 00:00:00'}
WEEKS 4
WEEKSELAPSED 42
WEEKSREMAINING 10
43
struct
CALENDARMONTH 4
CALENDARYEAR 2025
DAYSINPERIOD 30
ENDDATE {ts '2025-04-26 23:59:59'}
MONTHEND true
NAME Fiscal 2025 Week 43
PERIOD 10
QUARTER Q4
QUARTEREND false
QUARTERWEEKSELAPSED 4
STARTDATE {ts '2025-04-20 00:00:00'}
WEEKS 4
WEEKSELAPSED 43
WEEKSREMAINING 9
44
struct
CALENDARMONTH 4
CALENDARYEAR 2025
DAYSINPERIOD 30
ENDDATE {ts '2025-05-03 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 44
PERIOD 10
QUARTER Q4
QUARTEREND false
QUARTERWEEKSELAPSED 5
STARTDATE {ts '2025-04-27 00:00:00'}
WEEKS 4
WEEKSELAPSED 44
WEEKSREMAINING 8
45
struct
CALENDARMONTH 5
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-05-10 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 45
PERIOD 11
QUARTER Q4
QUARTEREND false
QUARTERWEEKSELAPSED 6
STARTDATE {ts '2025-05-04 00:00:00'}
WEEKS 4
WEEKSELAPSED 45
WEEKSREMAINING 7
46
struct
CALENDARMONTH 5
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-05-17 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 46
PERIOD 11
QUARTER Q4
QUARTEREND false
QUARTERWEEKSELAPSED 7
STARTDATE {ts '2025-05-11 00:00:00'}
WEEKS 4
WEEKSELAPSED 46
WEEKSREMAINING 6
47
struct
CALENDARMONTH 5
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-05-24 23:59:59'}
MONTHEND true
NAME Fiscal 2025 Week 47
PERIOD 11
QUARTER Q4
QUARTEREND false
QUARTERWEEKSELAPSED 8
STARTDATE {ts '2025-05-18 00:00:00'}
WEEKS 4
WEEKSELAPSED 47
WEEKSREMAINING 5
48
struct
CALENDARMONTH 5
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-05-31 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 48
PERIOD 11
QUARTER Q4
QUARTEREND false
QUARTERWEEKSELAPSED 9
STARTDATE {ts '2025-05-25 00:00:00'}
WEEKS 4
WEEKSELAPSED 48
WEEKSREMAINING 4
49
struct
CALENDARMONTH 6
CALENDARYEAR 2025
DAYSINPERIOD 30
ENDDATE {ts '2025-06-07 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 49
PERIOD 12
QUARTER Q4
QUARTEREND false
QUARTERWEEKSELAPSED 10
STARTDATE {ts '2025-06-01 00:00:00'}
WEEKS 5
WEEKSELAPSED 49
WEEKSREMAINING 3
50
struct
CALENDARMONTH 6
CALENDARYEAR 2025
DAYSINPERIOD 30
ENDDATE {ts '2025-06-14 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 50
PERIOD 12
QUARTER Q4
QUARTEREND false
QUARTERWEEKSELAPSED 11
STARTDATE {ts '2025-06-08 00:00:00'}
WEEKS 5
WEEKSELAPSED 50
WEEKSREMAINING 2
51
struct
CALENDARMONTH 6
CALENDARYEAR 2025
DAYSINPERIOD 30
ENDDATE {ts '2025-06-21 23:59:59'}
MONTHEND false
NAME Fiscal 2025 Week 51
PERIOD 12
QUARTER Q4
QUARTEREND false
QUARTERWEEKSELAPSED 12
STARTDATE {ts '2025-06-15 00:00:00'}
WEEKS 5
WEEKSELAPSED 51
WEEKSREMAINING 1
52
struct
CALENDARMONTH 6
CALENDARYEAR 2025
DAYSINPERIOD 30
ENDDATE {ts '2025-06-28 23:59:59'}
MONTHEND true
NAME Fiscal 2025 Week 52
PERIOD 12
QUARTER Q4
QUARTEREND true
QUARTERWEEKSELAPSED 13
STARTDATE {ts '2025-06-22 00:00:00'}
WEEKS 5
WEEKSELAPSED 52
WEEKSREMAINING 0
53
struct
CALENDARMONTH 6
CALENDARYEAR 2025
DAYSINPERIOD 30
ENDDATE {ts '2025-06-30 23:59:59'}
NAME Fiscal 2025 Week 53
PERIOD 12
QUARTER 4
STARTDATE {ts '2025-06-29 00:00:00'}
WEEKS 5
WEEKSELAPSED 53
WEEKSREMAINING -1
WEEKSELAPSED 0
Y1
struct
CALENDARMONTH 7,8,9,10,11,12,1,2,3,4,5,6
ENDDATE {ts '2025-06-30 23:59:59'}
NAME Fiscal 2025
PERIOD 1,2,3,4,5,6,7,8,9,10,11,12
STARTDATE {ts '2024-07-01 00:00:00'}
WEEKS 52
WEEKSELAPSED 52
WEEKSREMAINING 0
NY
struct
FISCALENDDATE {ts '2027-06-30 23:59:59'}
FISCALSTARTDATE {ts '2026-07-01 00:00:00'}
FISCALYEAR 2027
H1
struct
CALENDARMONTH 7,8,9,10,11,12
ENDDATE {ts '2026-12-31 23:59:59'}
ENDWEEK 26
NAME First Half 2027
PERIOD 1,2,3,4,5,6
STARTDATE {ts '2026-07-01 00:00:00'}
STARTWEEK 1
WEEKS 26
WEEKSELAPSED 26
WEEKSREMAINING 26
H2
struct
CALENDARMONTH 1,2,3,4,5,6
ENDDATE {ts '2027-06-30 23:59:59'}
ENDWEEK 52
NAME Second Half 2027
PERIOD 7,8,9,10,11,12
STARTDATE {ts '2027-01-01 00:00:00'}
STARTWEEK 27
WEEKS 26
WEEKSELAPSED 52
WEEKSREMAINING 0
MONTHS
array
1
struct
CALENDARMONTH 1
CALENDARYEAR 2027
DAYSINPERIOD 31
ENDDATE {ts '2027-01-31 23:59:59'}
ENDWEEK 30
NAME January 2027
PERIOD 7
QUARTER 3
STARTDATE {ts '2027-01-01 00:00:00'}
STARTWEEK 27
WEEKS 4
WEEKSELAPSED 30
WEEKSREMAINING 22
2
struct
CALENDARMONTH 2
CALENDARYEAR 2027
DAYSINPERIOD 28
ENDDATE {ts '2027-02-28 23:59:59'}
ENDWEEK 34
NAME February 2027
PERIOD 8
QUARTER 3
STARTDATE {ts '2027-02-01 00:00:00'}
STARTWEEK 31
WEEKS 4
WEEKSELAPSED 34
WEEKSREMAINING 18
3
struct
CALENDARMONTH 3
CALENDARYEAR 2027
DAYSINPERIOD 31
ENDDATE {ts '2027-03-31 23:59:59'}
ENDWEEK 39
NAME March 2027
PERIOD 9
QUARTER 3
STARTDATE {ts '2027-03-01 00:00:00'}
STARTWEEK 35
WEEKS 5
WEEKSELAPSED 39
WEEKSREMAINING 13
4
struct
CALENDARMONTH 4
CALENDARYEAR 2027
DAYSINPERIOD 30
ENDDATE {ts '2027-04-30 23:59:59'}
ENDWEEK 43
NAME April 2027
PERIOD 10
QUARTER 4
STARTDATE {ts '2027-04-01 00:00:00'}
STARTWEEK 40
WEEKS 4
WEEKSELAPSED 43
WEEKSREMAINING 9
5
struct
CALENDARMONTH 5
CALENDARYEAR 2027
DAYSINPERIOD 31
ENDDATE {ts '2027-05-31 23:59:59'}
ENDWEEK 47
NAME May 2027
PERIOD 11
QUARTER 4
STARTDATE {ts '2027-05-01 00:00:00'}
STARTWEEK 44
WEEKS 4
WEEKSELAPSED 47
WEEKSREMAINING 5
6
struct
CALENDARMONTH 6
CALENDARYEAR 2027
DAYSINPERIOD 30
ENDDATE {ts '2027-06-30 23:59:59'}
ENDWEEK 52
NAME June 2027
PERIOD 12
QUARTER 4
STARTDATE {ts '2027-06-01 00:00:00'}
STARTWEEK 48
WEEKS 5
WEEKSELAPSED 52
WEEKSREMAINING 0
7
struct
CALENDARMONTH 7
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-07-31 23:59:59'}
ENDWEEK 4
NAME July 2026
PERIOD 1
QUARTER 1
STARTDATE {ts '2026-07-01 00:00:00'}
STARTWEEK 1
WEEKS 4
WEEKSELAPSED 4
WEEKSREMAINING 48
8
struct
CALENDARMONTH 8
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-08-31 23:59:59'}
ENDWEEK 8
NAME August 2026
PERIOD 2
QUARTER 1
STARTDATE {ts '2026-08-01 00:00:00'}
STARTWEEK 5
WEEKS 4
WEEKSELAPSED 8
WEEKSREMAINING 44
9
struct
CALENDARMONTH 9
CALENDARYEAR 2026
DAYSINPERIOD 30
ENDDATE {ts '2026-09-30 23:59:59'}
ENDWEEK 13
NAME September 2026
PERIOD 3
QUARTER 1
STARTDATE {ts '2026-09-01 00:00:00'}
STARTWEEK 9
WEEKS 5
WEEKSELAPSED 13
WEEKSREMAINING 39
10
struct
CALENDARMONTH 10
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-10-31 23:59:59'}
ENDWEEK 17
NAME October 2026
PERIOD 4
QUARTER 2
STARTDATE {ts '2026-10-01 00:00:00'}
STARTWEEK 14
WEEKS 4
WEEKSELAPSED 17
WEEKSREMAINING 35
11
struct
CALENDARMONTH 11
CALENDARYEAR 2026
DAYSINPERIOD 30
ENDDATE {ts '2026-11-30 23:59:59'}
ENDWEEK 21
NAME November 2026
PERIOD 5
QUARTER 2
STARTDATE {ts '2026-11-01 00:00:00'}
STARTWEEK 18
WEEKS 4
WEEKSELAPSED 21
WEEKSREMAINING 31
12
struct
CALENDARMONTH 12
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-12-31 23:59:59'}
ENDWEEK 26
NAME December 2026
PERIOD 6
QUARTER 2
STARTDATE {ts '2026-12-01 00:00:00'}
STARTWEEK 22
WEEKS 5
WEEKSELAPSED 26
WEEKSREMAINING 26
PERIODS
array
1
struct
CALENDARMONTH 7
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-07-31 23:59:59'}
ENDWEEK 4
NAME July 2026
PERIOD 1
QUARTER 1
STARTDATE {ts '2026-07-01 00:00:00'}
STARTWEEK 1
WEEKS 4
WEEKSELAPSED 4
WEEKSREMAINING 48
2
struct
CALENDARMONTH 8
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-08-31 23:59:59'}
ENDWEEK 8
NAME August 2026
PERIOD 2
QUARTER 1
STARTDATE {ts '2026-08-01 00:00:00'}
STARTWEEK 5
WEEKS 4
WEEKSELAPSED 8
WEEKSREMAINING 44
3
struct
CALENDARMONTH 9
CALENDARYEAR 2026
DAYSINPERIOD 30
ENDDATE {ts '2026-09-30 23:59:59'}
ENDWEEK 13
NAME September 2026
PERIOD 3
QUARTER 1
STARTDATE {ts '2026-09-01 00:00:00'}
STARTWEEK 9
WEEKS 5
WEEKSELAPSED 13
WEEKSREMAINING 39
4
struct
CALENDARMONTH 10
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-10-31 23:59:59'}
ENDWEEK 17
NAME October 2026
PERIOD 4
QUARTER 2
STARTDATE {ts '2026-10-01 00:00:00'}
STARTWEEK 14
WEEKS 4
WEEKSELAPSED 17
WEEKSREMAINING 35
5
struct
CALENDARMONTH 11
CALENDARYEAR 2026
DAYSINPERIOD 30
ENDDATE {ts '2026-11-30 23:59:59'}
ENDWEEK 21
NAME November 2026
PERIOD 5
QUARTER 2
STARTDATE {ts '2026-11-01 00:00:00'}
STARTWEEK 18
WEEKS 4
WEEKSELAPSED 21
WEEKSREMAINING 31
6
struct
CALENDARMONTH 12
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-12-31 23:59:59'}
ENDWEEK 26
NAME December 2026
PERIOD 6
QUARTER 2
STARTDATE {ts '2026-12-01 00:00:00'}
STARTWEEK 22
WEEKS 5
WEEKSELAPSED 26
WEEKSREMAINING 26
7
struct
CALENDARMONTH 1
CALENDARYEAR 2027
DAYSINPERIOD 31
ENDDATE {ts '2027-01-31 23:59:59'}
ENDWEEK 30
NAME January 2027
PERIOD 7
QUARTER 3
STARTDATE {ts '2027-01-01 00:00:00'}
STARTWEEK 27
WEEKS 4
WEEKSELAPSED 30
WEEKSREMAINING 22
8
struct
CALENDARMONTH 2
CALENDARYEAR 2027
DAYSINPERIOD 28
ENDDATE {ts '2027-02-28 23:59:59'}
ENDWEEK 34
NAME February 2027
PERIOD 8
QUARTER 3
STARTDATE {ts '2027-02-01 00:00:00'}
STARTWEEK 31
WEEKS 4
WEEKSELAPSED 34
WEEKSREMAINING 18
9
struct
CALENDARMONTH 3
CALENDARYEAR 2027
DAYSINPERIOD 31
ENDDATE {ts '2027-03-31 23:59:59'}
ENDWEEK 39
NAME March 2027
PERIOD 9
QUARTER 3
STARTDATE {ts '2027-03-01 00:00:00'}
STARTWEEK 35
WEEKS 5
WEEKSELAPSED 39
WEEKSREMAINING 13
10
struct
CALENDARMONTH 4
CALENDARYEAR 2027
DAYSINPERIOD 30
ENDDATE {ts '2027-04-30 23:59:59'}
ENDWEEK 43
NAME April 2027
PERIOD 10
QUARTER 4
STARTDATE {ts '2027-04-01 00:00:00'}
STARTWEEK 40
WEEKS 4
WEEKSELAPSED 43
WEEKSREMAINING 9
11
struct
CALENDARMONTH 5
CALENDARYEAR 2027
DAYSINPERIOD 31
ENDDATE {ts '2027-05-31 23:59:59'}
ENDWEEK 47
NAME May 2027
PERIOD 11
QUARTER 4
STARTDATE {ts '2027-05-01 00:00:00'}
STARTWEEK 44
WEEKS 4
WEEKSELAPSED 47
WEEKSREMAINING 5
12
struct
CALENDARMONTH 6
CALENDARYEAR 2027
DAYSINPERIOD 30
ENDDATE {ts '2027-06-30 23:59:59'}
ENDWEEK 52
NAME June 2027
PERIOD 12
QUARTER 4
STARTDATE {ts '2027-06-01 00:00:00'}
STARTWEEK 48
WEEKS 5
WEEKSELAPSED 52
WEEKSREMAINING 0
Q1
struct
CALENDARMONTH 7,8,9
ENDDATE {ts '2026-09-30 23:59:59'}
ENDWEEK 13
NAME Q1 2027
PERIOD 1,2,3
QUARTER 1
STARTDATE {ts '2026-07-01 00:00:00'}
STARTWEEK 1
WEEKS 13
WEEKSELAPSED 13
WEEKSREMAINING 39
Q2
struct
CALENDARMONTH 10,11,12
ENDDATE {ts '2026-12-31 23:59:59'}
ENDWEEK 26
NAME Q2 2027
PERIOD 4,5,6
QUARTER 2
STARTDATE {ts '2026-10-01 00:00:00'}
STARTWEEK 14
WEEKS 13
WEEKSELAPSED 26
WEEKSREMAINING 26
Q3
struct
CALENDARMONTH 1,2,3
ENDDATE {ts '2027-03-31 23:59:59'}
ENDWEEK 39
NAME Q3 2027
PERIOD 7,8,9
QUARTER 3
STARTDATE {ts '2027-01-01 00:00:00'}
STARTWEEK 27
WEEKS 13
WEEKSELAPSED 39
WEEKSREMAINING 13
Q4
struct
CALENDARMONTH 4,5,6
ENDDATE {ts '2027-06-30 23:59:59'}
ENDWEEK 52
NAME Q4 2027
PERIOD 10,11,12
QUARTER 4
STARTDATE {ts '2027-04-01 00:00:00'}
STARTWEEK 40
WEEKS 13
WEEKSELAPSED 52
WEEKSREMAINING 0
T1
struct
CALENDARMONTH 7,8,9,10
ENDDATE {ts '2026-10-31 23:59:59'}
ENDWEEK 17
NAME First Trimester 2027
PERIOD 1,2,3,4
STARTDATE {ts '2026-07-01 00:00:00'}
STARTWEEK 1
WEEKS 17
WEEKSELAPSED 17
WEEKSREMAINING 35
T2
struct
CALENDARMONTH 11,12,1,2
ENDDATE {ts '2027-02-28 23:59:59'}
ENDWEEK 34
NAME Second Trimester 2027
PERIOD 5,6,7,8
STARTDATE {ts '2026-11-01 00:00:00'}
STARTWEEK 18
WEEKS 17
WEEKSELAPSED 34
WEEKSREMAINING 18
T3
struct
CALENDARMONTH 3,4,5,6
ENDDATE {ts '2027-06-30 23:59:59'}
ENDWEEK 52
NAME Third Trimester 2027
PERIOD 9,10,11,12
STARTDATE {ts '2027-03-01 00:00:00'}
STARTWEEK 35
WEEKS 18
WEEKSELAPSED 52
WEEKSREMAINING 0
TOTALWEEKS 52
WEEKS
array
1
struct
CALENDARMONTH 7
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-07-04 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 1
PERIOD 1
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 1
STARTDATE {ts '2026-07-01 00:00:00'}
WEEKS 4
WEEKSELAPSED 1
WEEKSREMAINING 51
2
struct
CALENDARMONTH 7
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-07-11 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 2
PERIOD 1
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 2
STARTDATE {ts '2026-07-05 00:00:00'}
WEEKS 4
WEEKSELAPSED 2
WEEKSREMAINING 50
3
struct
CALENDARMONTH 7
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-07-18 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 3
PERIOD 1
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 3
STARTDATE {ts '2026-07-12 00:00:00'}
WEEKS 4
WEEKSELAPSED 3
WEEKSREMAINING 49
4
struct
CALENDARMONTH 7
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-07-25 23:59:59'}
MONTHEND true
NAME Fiscal 2027 Week 4
PERIOD 1
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 4
STARTDATE {ts '2026-07-19 00:00:00'}
WEEKS 4
WEEKSELAPSED 4
WEEKSREMAINING 48
5
struct
CALENDARMONTH 7
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-08-01 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 5
PERIOD 1
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 5
STARTDATE {ts '2026-07-26 00:00:00'}
WEEKS 4
WEEKSELAPSED 5
WEEKSREMAINING 47
6
struct
CALENDARMONTH 8
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-08-08 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 6
PERIOD 2
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 6
STARTDATE {ts '2026-08-02 00:00:00'}
WEEKS 4
WEEKSELAPSED 6
WEEKSREMAINING 46
7
struct
CALENDARMONTH 8
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-08-15 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 7
PERIOD 2
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 7
STARTDATE {ts '2026-08-09 00:00:00'}
WEEKS 4
WEEKSELAPSED 7
WEEKSREMAINING 45
8
struct
CALENDARMONTH 8
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-08-22 23:59:59'}
MONTHEND true
NAME Fiscal 2027 Week 8
PERIOD 2
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 8
STARTDATE {ts '2026-08-16 00:00:00'}
WEEKS 4
WEEKSELAPSED 8
WEEKSREMAINING 44
9
struct
CALENDARMONTH 8
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-08-29 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 9
PERIOD 2
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 9
STARTDATE {ts '2026-08-23 00:00:00'}
WEEKS 4
WEEKSELAPSED 9
WEEKSREMAINING 43
10
struct
CALENDARMONTH 8
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-09-05 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 10
PERIOD 2
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 10
STARTDATE {ts '2026-08-30 00:00:00'}
WEEKS 4
WEEKSELAPSED 10
WEEKSREMAINING 42
11
struct
CALENDARMONTH 9
CALENDARYEAR 2026
DAYSINPERIOD 30
ENDDATE {ts '2026-09-12 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 11
PERIOD 3
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 11
STARTDATE {ts '2026-09-06 00:00:00'}
WEEKS 5
WEEKSELAPSED 11
WEEKSREMAINING 41
12
struct
CALENDARMONTH 9
CALENDARYEAR 2026
DAYSINPERIOD 30
ENDDATE {ts '2026-09-19 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 12
PERIOD 3
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 12
STARTDATE {ts '2026-09-13 00:00:00'}
WEEKS 5
WEEKSELAPSED 12
WEEKSREMAINING 40
13
struct
CALENDARMONTH 9
CALENDARYEAR 2026
DAYSINPERIOD 30
ENDDATE {ts '2026-09-26 23:59:59'}
MONTHEND true
NAME Fiscal 2027 Week 13
PERIOD 3
QUARTER Q1
QUARTEREND true
QUARTERWEEKSELAPSED 13
STARTDATE {ts '2026-09-20 00:00:00'}
WEEKS 5
WEEKSELAPSED 13
WEEKSREMAINING 39
14
struct
CALENDARMONTH 9
CALENDARYEAR 2026
DAYSINPERIOD 30
ENDDATE {ts '2026-10-03 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 14
PERIOD 3
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 14
STARTDATE {ts '2026-09-27 00:00:00'}
WEEKS 5
WEEKSELAPSED 14
WEEKSREMAINING 38
15
struct
CALENDARMONTH 10
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-10-10 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 15
PERIOD 4
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 2
STARTDATE {ts '2026-10-04 00:00:00'}
WEEKS 4
WEEKSELAPSED 15
WEEKSREMAINING 37
16
struct
CALENDARMONTH 10
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-10-17 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 16
PERIOD 4
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 3
STARTDATE {ts '2026-10-11 00:00:00'}
WEEKS 4
WEEKSELAPSED 16
WEEKSREMAINING 36
17
struct
CALENDARMONTH 10
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-10-24 23:59:59'}
MONTHEND true
NAME Fiscal 2027 Week 17
PERIOD 4
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 4
STARTDATE {ts '2026-10-18 00:00:00'}
WEEKS 4
WEEKSELAPSED 17
WEEKSREMAINING 35
18
struct
CALENDARMONTH 10
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-10-31 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 18
PERIOD 4
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 5
STARTDATE {ts '2026-10-25 00:00:00'}
WEEKS 4
WEEKSELAPSED 18
WEEKSREMAINING 34
19
struct
CALENDARMONTH 11
CALENDARYEAR 2026
DAYSINPERIOD 30
ENDDATE {ts '2026-11-07 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 19
PERIOD 5
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 6
STARTDATE {ts '2026-11-01 00:00:00'}
WEEKS 4
WEEKSELAPSED 19
WEEKSREMAINING 33
20
struct
CALENDARMONTH 11
CALENDARYEAR 2026
DAYSINPERIOD 30
ENDDATE {ts '2026-11-14 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 20
PERIOD 5
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 7
STARTDATE {ts '2026-11-08 00:00:00'}
WEEKS 4
WEEKSELAPSED 20
WEEKSREMAINING 32
21
struct
CALENDARMONTH 11
CALENDARYEAR 2026
DAYSINPERIOD 30
ENDDATE {ts '2026-11-21 23:59:59'}
MONTHEND true
NAME Fiscal 2027 Week 21
PERIOD 5
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 8
STARTDATE {ts '2026-11-15 00:00:00'}
WEEKS 4
WEEKSELAPSED 21
WEEKSREMAINING 31
22
struct
CALENDARMONTH 11
CALENDARYEAR 2026
DAYSINPERIOD 30
ENDDATE {ts '2026-11-28 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 22
PERIOD 5
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 9
STARTDATE {ts '2026-11-22 00:00:00'}
WEEKS 4
WEEKSELAPSED 22
WEEKSREMAINING 30
23
struct
CALENDARMONTH 11
CALENDARYEAR 2026
DAYSINPERIOD 30
ENDDATE {ts '2026-12-05 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 23
PERIOD 5
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 10
STARTDATE {ts '2026-11-29 00:00:00'}
WEEKS 4
WEEKSELAPSED 23
WEEKSREMAINING 29
24
struct
CALENDARMONTH 12
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-12-12 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 24
PERIOD 6
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 11
STARTDATE {ts '2026-12-06 00:00:00'}
WEEKS 5
WEEKSELAPSED 24
WEEKSREMAINING 28
25
struct
CALENDARMONTH 12
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-12-19 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 25
PERIOD 6
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 12
STARTDATE {ts '2026-12-13 00:00:00'}
WEEKS 5
WEEKSELAPSED 25
WEEKSREMAINING 27
26
struct
CALENDARMONTH 12
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-12-26 23:59:59'}
MONTHEND true
NAME Fiscal 2027 Week 26
PERIOD 6
QUARTER Q2
QUARTEREND true
QUARTERWEEKSELAPSED 13
STARTDATE {ts '2026-12-20 00:00:00'}
WEEKS 5
WEEKSELAPSED 26
WEEKSREMAINING 26
27
struct
CALENDARMONTH 12
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2027-01-02 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 27
PERIOD 6
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 14
STARTDATE {ts '2026-12-27 00:00:00'}
WEEKS 5
WEEKSELAPSED 27
WEEKSREMAINING 25
28
struct
CALENDARMONTH 1
CALENDARYEAR 2027
DAYSINPERIOD 31
ENDDATE {ts '2027-01-09 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 28
PERIOD 7
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 2
STARTDATE {ts '2027-01-03 00:00:00'}
WEEKS 4
WEEKSELAPSED 28
WEEKSREMAINING 24
29
struct
CALENDARMONTH 1
CALENDARYEAR 2027
DAYSINPERIOD 31
ENDDATE {ts '2027-01-16 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 29
PERIOD 7
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 3
STARTDATE {ts '2027-01-10 00:00:00'}
WEEKS 4
WEEKSELAPSED 29
WEEKSREMAINING 23
30
struct
CALENDARMONTH 1
CALENDARYEAR 2027
DAYSINPERIOD 31
ENDDATE {ts '2027-01-23 23:59:59'}
MONTHEND true
NAME Fiscal 2027 Week 30
PERIOD 7
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 4
STARTDATE {ts '2027-01-17 00:00:00'}
WEEKS 4
WEEKSELAPSED 30
WEEKSREMAINING 22
31
struct
CALENDARMONTH 1
CALENDARYEAR 2027
DAYSINPERIOD 31
ENDDATE {ts '2027-01-30 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 31
PERIOD 7
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 5
STARTDATE {ts '2027-01-24 00:00:00'}
WEEKS 4
WEEKSELAPSED 31
WEEKSREMAINING 21
32
struct
CALENDARMONTH 1
CALENDARYEAR 2027
DAYSINPERIOD 31
ENDDATE {ts '2027-02-06 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 32
PERIOD 7
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 6
STARTDATE {ts '2027-01-31 00:00:00'}
WEEKS 4
WEEKSELAPSED 32
WEEKSREMAINING 20
33
struct
CALENDARMONTH 2
CALENDARYEAR 2027
DAYSINPERIOD 28
ENDDATE {ts '2027-02-13 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 33
PERIOD 8
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 7
STARTDATE {ts '2027-02-07 00:00:00'}
WEEKS 4
WEEKSELAPSED 33
WEEKSREMAINING 19
34
struct
CALENDARMONTH 2
CALENDARYEAR 2027
DAYSINPERIOD 28
ENDDATE {ts '2027-02-20 23:59:59'}
MONTHEND true
NAME Fiscal 2027 Week 34
PERIOD 8
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 8
STARTDATE {ts '2027-02-14 00:00:00'}
WEEKS 4
WEEKSELAPSED 34
WEEKSREMAINING 18
35
struct
CALENDARMONTH 2
CALENDARYEAR 2027
DAYSINPERIOD 28
ENDDATE {ts '2027-02-27 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 35
PERIOD 8
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 9
STARTDATE {ts '2027-02-21 00:00:00'}
WEEKS 4
WEEKSELAPSED 35
WEEKSREMAINING 17
36
struct
CALENDARMONTH 2
CALENDARYEAR 2027
DAYSINPERIOD 28
ENDDATE {ts '2027-03-06 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 36
PERIOD 8
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 10
STARTDATE {ts '2027-02-28 00:00:00'}
WEEKS 4
WEEKSELAPSED 36
WEEKSREMAINING 16
37
struct
CALENDARMONTH 3
CALENDARYEAR 2027
DAYSINPERIOD 31
ENDDATE {ts '2027-03-13 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 37
PERIOD 9
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 11
STARTDATE {ts '2027-03-07 00:00:00'}
WEEKS 5
WEEKSELAPSED 37
WEEKSREMAINING 15
38
struct
CALENDARMONTH 3
CALENDARYEAR 2027
DAYSINPERIOD 31
ENDDATE {ts '2027-03-20 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 38
PERIOD 9
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 12
STARTDATE {ts '2027-03-14 00:00:00'}
WEEKS 5
WEEKSELAPSED 38
WEEKSREMAINING 14
39
struct
CALENDARMONTH 3
CALENDARYEAR 2027
DAYSINPERIOD 31
ENDDATE {ts '2027-03-27 23:59:59'}
MONTHEND true
NAME Fiscal 2027 Week 39
PERIOD 9
QUARTER Q3
QUARTEREND true
QUARTERWEEKSELAPSED 13
STARTDATE {ts '2027-03-21 00:00:00'}
WEEKS 5
WEEKSELAPSED 39
WEEKSREMAINING 13
40
struct
CALENDARMONTH 3
CALENDARYEAR 2027
DAYSINPERIOD 31
ENDDATE {ts '2027-04-03 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 40
PERIOD 9
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 14
STARTDATE {ts '2027-03-28 00:00:00'}
WEEKS 5
WEEKSELAPSED 40
WEEKSREMAINING 12
41
struct
CALENDARMONTH 4
CALENDARYEAR 2027
DAYSINPERIOD 30
ENDDATE {ts '2027-04-10 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 41
PERIOD 10
QUARTER Q4
QUARTEREND false
QUARTERWEEKSELAPSED 2
STARTDATE {ts '2027-04-04 00:00:00'}
WEEKS 4
WEEKSELAPSED 41
WEEKSREMAINING 11
42
struct
CALENDARMONTH 4
CALENDARYEAR 2027
DAYSINPERIOD 30
ENDDATE {ts '2027-04-17 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 42
PERIOD 10
QUARTER Q4
QUARTEREND false
QUARTERWEEKSELAPSED 3
STARTDATE {ts '2027-04-11 00:00:00'}
WEEKS 4
WEEKSELAPSED 42
WEEKSREMAINING 10
43
struct
CALENDARMONTH 4
CALENDARYEAR 2027
DAYSINPERIOD 30
ENDDATE {ts '2027-04-24 23:59:59'}
MONTHEND true
NAME Fiscal 2027 Week 43
PERIOD 10
QUARTER Q4
QUARTEREND false
QUARTERWEEKSELAPSED 4
STARTDATE {ts '2027-04-18 00:00:00'}
WEEKS 4
WEEKSELAPSED 43
WEEKSREMAINING 9
44
struct
CALENDARMONTH 4
CALENDARYEAR 2027
DAYSINPERIOD 30
ENDDATE {ts '2027-05-01 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 44
PERIOD 10
QUARTER Q4
QUARTEREND false
QUARTERWEEKSELAPSED 5
STARTDATE {ts '2027-04-25 00:00:00'}
WEEKS 4
WEEKSELAPSED 44
WEEKSREMAINING 8
45
struct
CALENDARMONTH 5
CALENDARYEAR 2027
DAYSINPERIOD 31
ENDDATE {ts '2027-05-08 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 45
PERIOD 11
QUARTER Q4
QUARTEREND false
QUARTERWEEKSELAPSED 6
STARTDATE {ts '2027-05-02 00:00:00'}
WEEKS 4
WEEKSELAPSED 45
WEEKSREMAINING 7
46
struct
CALENDARMONTH 5
CALENDARYEAR 2027
DAYSINPERIOD 31
ENDDATE {ts '2027-05-15 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 46
PERIOD 11
QUARTER Q4
QUARTEREND false
QUARTERWEEKSELAPSED 7
STARTDATE {ts '2027-05-09 00:00:00'}
WEEKS 4
WEEKSELAPSED 46
WEEKSREMAINING 6
47
struct
CALENDARMONTH 5
CALENDARYEAR 2027
DAYSINPERIOD 31
ENDDATE {ts '2027-05-22 23:59:59'}
MONTHEND true
NAME Fiscal 2027 Week 47
PERIOD 11
QUARTER Q4
QUARTEREND false
QUARTERWEEKSELAPSED 8
STARTDATE {ts '2027-05-16 00:00:00'}
WEEKS 4
WEEKSELAPSED 47
WEEKSREMAINING 5
48
struct
CALENDARMONTH 5
CALENDARYEAR 2027
DAYSINPERIOD 31
ENDDATE {ts '2027-05-29 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 48
PERIOD 11
QUARTER Q4
QUARTEREND false
QUARTERWEEKSELAPSED 9
STARTDATE {ts '2027-05-23 00:00:00'}
WEEKS 4
WEEKSELAPSED 48
WEEKSREMAINING 4
49
struct
CALENDARMONTH 5
CALENDARYEAR 2027
DAYSINPERIOD 31
ENDDATE {ts '2027-06-05 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 49
PERIOD 11
QUARTER Q4
QUARTEREND false
QUARTERWEEKSELAPSED 10
STARTDATE {ts '2027-05-30 00:00:00'}
WEEKS 4
WEEKSELAPSED 49
WEEKSREMAINING 3
50
struct
CALENDARMONTH 6
CALENDARYEAR 2027
DAYSINPERIOD 30
ENDDATE {ts '2027-06-12 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 50
PERIOD 12
QUARTER Q4
QUARTEREND false
QUARTERWEEKSELAPSED 11
STARTDATE {ts '2027-06-06 00:00:00'}
WEEKS 5
WEEKSELAPSED 50
WEEKSREMAINING 2
51
struct
CALENDARMONTH 6
CALENDARYEAR 2027
DAYSINPERIOD 30
ENDDATE {ts '2027-06-19 23:59:59'}
MONTHEND false
NAME Fiscal 2027 Week 51
PERIOD 12
QUARTER Q4
QUARTEREND false
QUARTERWEEKSELAPSED 12
STARTDATE {ts '2027-06-13 00:00:00'}
WEEKS 5
WEEKSELAPSED 51
WEEKSREMAINING 1
52
struct
CALENDARMONTH 6
CALENDARYEAR 2027
DAYSINPERIOD 30
ENDDATE {ts '2027-06-26 23:59:59'}
MONTHEND true
NAME Fiscal 2027 Week 52
PERIOD 12
QUARTER Q4
QUARTEREND true
QUARTERWEEKSELAPSED 13
STARTDATE {ts '2027-06-20 00:00:00'}
WEEKS 5
WEEKSELAPSED 52
WEEKSREMAINING 0
53
struct
CALENDARMONTH 6
CALENDARYEAR 2027
DAYSINPERIOD 30
ENDDATE {ts '2027-06-30 23:59:59'}
NAME Fiscal 2027 Week 53
PERIOD 12
QUARTER 4
STARTDATE {ts '2027-06-27 00:00:00'}
WEEKS 5
WEEKSELAPSED 53
WEEKSREMAINING -1
WEEKSELAPSED 0
Y1
struct
CALENDARMONTH 7,8,9,10,11,12,1,2,3,4,5,6
ENDDATE {ts '2027-06-30 23:59:59'}
NAME Fiscal 2027
PERIOD 1,2,3,4,5,6,7,8,9,10,11,12
STARTDATE {ts '2026-07-01 00:00:00'}
WEEKS 52
WEEKSELAPSED 52
WEEKSREMAINING 0
RULES
query
  CALENDARTYPE DSTCOMPANYTYPE DSTPARENTCO FISCALYEARENDMONTH FISCALYEARSTARTDAY FISCALYEARSTARTMONTH STARTOFWEEK WEEKSINMONTH
1 CALENDAR P 7916 6 1 7 1 [empty string]
TY
struct
CURRENTPERIOD
struct
CALENDARMONTH 4
CALENDARYEAR 2026
DAYSELAPSED 15
DAYSINPERIOD 30
ENDDATE {ts '2026-04-30 23:59:59'}
NAME April 2026
PERIOD 10
PORTIONCOMPLETE 0.5
QUARTER 4
STARTDATE {ts '2026-04-01 00:00:00'}
WEEKS 4
WEEKSELAPSED 43
WEEKSREMAINING 9
FISCALENDDATE {ts '2026-06-30 23:59:59'}
FISCALSTARTDATE {ts '2025-07-01 00:00:00'}
FISCALYEAR 2026
H1
struct
CALENDARMONTH 7,8,9,10,11,12
ENDDATE {ts '2025-12-31 23:59:59'}
ENDWEEK 26
NAME First Half 2026
PERIOD 1,2,3,4,5,6
STARTDATE {ts '2025-07-01 00:00:00'}
STARTWEEK 1
WEEKS 26
WEEKSELAPSED 26
WEEKSREMAINING 26
H2
struct
CALENDARMONTH 1,2,3,4,5,6
ENDDATE {ts '2026-06-30 23:59:59'}
ENDWEEK 52
NAME Second Half 2026
PERIOD 7,8,9,10,11,12
STARTDATE {ts '2026-01-01 00:00:00'}
STARTWEEK 27
WEEKS 26
WEEKSELAPSED 52
WEEKSREMAINING 0
MONTHS
array
1
struct
CALENDARMONTH 1
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-01-31 23:59:59'}
ENDWEEK 30
NAME January 2026
PERIOD 7
QUARTER 3
STARTDATE {ts '2026-01-01 00:00:00'}
STARTWEEK 27
WEEKS 4
WEEKSELAPSED 30
WEEKSREMAINING 22
2
struct
CALENDARMONTH 2
CALENDARYEAR 2026
DAYSINPERIOD 28
ENDDATE {ts '2026-02-28 23:59:59'}
ENDWEEK 34
NAME February 2026
PERIOD 8
QUARTER 3
STARTDATE {ts '2026-02-01 00:00:00'}
STARTWEEK 31
WEEKS 4
WEEKSELAPSED 34
WEEKSREMAINING 18
3
struct
CALENDARMONTH 3
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-03-31 23:59:59'}
ENDWEEK 39
NAME March 2026
PERIOD 9
QUARTER 3
STARTDATE {ts '2026-03-01 00:00:00'}
STARTWEEK 35
WEEKS 5
WEEKSELAPSED 39
WEEKSREMAINING 13
4
struct
CALENDARMONTH 4
CALENDARYEAR 2026
DAYSINPERIOD 30
ENDDATE {ts '2026-04-30 23:59:59'}
ENDWEEK 43
NAME April 2026
PERIOD 10
QUARTER 4
STARTDATE {ts '2026-04-01 00:00:00'}
STARTWEEK 40
WEEKS 4
WEEKSELAPSED 43
WEEKSREMAINING 9
5
struct
CALENDARMONTH 5
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-05-31 23:59:59'}
ENDWEEK 47
NAME May 2026
PERIOD 11
QUARTER 4
STARTDATE {ts '2026-05-01 00:00:00'}
STARTWEEK 44
WEEKS 4
WEEKSELAPSED 47
WEEKSREMAINING 5
6
struct
CALENDARMONTH 6
CALENDARYEAR 2026
DAYSINPERIOD 30
ENDDATE {ts '2026-06-30 23:59:59'}
ENDWEEK 52
NAME June 2026
PERIOD 12
QUARTER 4
STARTDATE {ts '2026-06-01 00:00:00'}
STARTWEEK 48
WEEKS 5
WEEKSELAPSED 52
WEEKSREMAINING 0
7
struct
CALENDARMONTH 7
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-07-31 23:59:59'}
ENDWEEK 4
NAME July 2025
PERIOD 1
QUARTER 1
STARTDATE {ts '2025-07-01 00:00:00'}
STARTWEEK 1
WEEKS 4
WEEKSELAPSED 4
WEEKSREMAINING 48
8
struct
CALENDARMONTH 8
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-08-31 23:59:59'}
ENDWEEK 8
NAME August 2025
PERIOD 2
QUARTER 1
STARTDATE {ts '2025-08-01 00:00:00'}
STARTWEEK 5
WEEKS 4
WEEKSELAPSED 8
WEEKSREMAINING 44
9
struct
CALENDARMONTH 9
CALENDARYEAR 2025
DAYSINPERIOD 30
ENDDATE {ts '2025-09-30 23:59:59'}
ENDWEEK 13
NAME September 2025
PERIOD 3
QUARTER 1
STARTDATE {ts '2025-09-01 00:00:00'}
STARTWEEK 9
WEEKS 5
WEEKSELAPSED 13
WEEKSREMAINING 39
10
struct
CALENDARMONTH 10
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-10-31 23:59:59'}
ENDWEEK 17
NAME October 2025
PERIOD 4
QUARTER 2
STARTDATE {ts '2025-10-01 00:00:00'}
STARTWEEK 14
WEEKS 4
WEEKSELAPSED 17
WEEKSREMAINING 35
11
struct
CALENDARMONTH 11
CALENDARYEAR 2025
DAYSINPERIOD 30
ENDDATE {ts '2025-11-30 23:59:59'}
ENDWEEK 21
NAME November 2025
PERIOD 5
QUARTER 2
STARTDATE {ts '2025-11-01 00:00:00'}
STARTWEEK 18
WEEKS 4
WEEKSELAPSED 21
WEEKSREMAINING 31
12
struct
CALENDARMONTH 12
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-12-31 23:59:59'}
ENDWEEK 26
NAME December 2025
PERIOD 6
QUARTER 2
STARTDATE {ts '2025-12-01 00:00:00'}
STARTWEEK 22
WEEKS 5
WEEKSELAPSED 26
WEEKSREMAINING 26
PERIODS
array
1
struct
CALENDARMONTH 7
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-07-31 23:59:59'}
ENDWEEK 4
NAME July 2025
PERIOD 1
QUARTER 1
STARTDATE {ts '2025-07-01 00:00:00'}
STARTWEEK 1
WEEKS 4
WEEKSELAPSED 4
WEEKSREMAINING 48
2
struct
CALENDARMONTH 8
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-08-31 23:59:59'}
ENDWEEK 8
NAME August 2025
PERIOD 2
QUARTER 1
STARTDATE {ts '2025-08-01 00:00:00'}
STARTWEEK 5
WEEKS 4
WEEKSELAPSED 8
WEEKSREMAINING 44
3
struct
CALENDARMONTH 9
CALENDARYEAR 2025
DAYSINPERIOD 30
ENDDATE {ts '2025-09-30 23:59:59'}
ENDWEEK 13
NAME September 2025
PERIOD 3
QUARTER 1
STARTDATE {ts '2025-09-01 00:00:00'}
STARTWEEK 9
WEEKS 5
WEEKSELAPSED 13
WEEKSREMAINING 39
4
struct
CALENDARMONTH 10
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-10-31 23:59:59'}
ENDWEEK 17
NAME October 2025
PERIOD 4
QUARTER 2
STARTDATE {ts '2025-10-01 00:00:00'}
STARTWEEK 14
WEEKS 4
WEEKSELAPSED 17
WEEKSREMAINING 35
5
struct
CALENDARMONTH 11
CALENDARYEAR 2025
DAYSINPERIOD 30
ENDDATE {ts '2025-11-30 23:59:59'}
ENDWEEK 21
NAME November 2025
PERIOD 5
QUARTER 2
STARTDATE {ts '2025-11-01 00:00:00'}
STARTWEEK 18
WEEKS 4
WEEKSELAPSED 21
WEEKSREMAINING 31
6
struct
CALENDARMONTH 12
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-12-31 23:59:59'}
ENDWEEK 26
NAME December 2025
PERIOD 6
QUARTER 2
STARTDATE {ts '2025-12-01 00:00:00'}
STARTWEEK 22
WEEKS 5
WEEKSELAPSED 26
WEEKSREMAINING 26
7
struct
CALENDARMONTH 1
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-01-31 23:59:59'}
ENDWEEK 30
NAME January 2026
PERIOD 7
QUARTER 3
STARTDATE {ts '2026-01-01 00:00:00'}
STARTWEEK 27
WEEKS 4
WEEKSELAPSED 30
WEEKSREMAINING 22
8
struct
CALENDARMONTH 2
CALENDARYEAR 2026
DAYSINPERIOD 28
ENDDATE {ts '2026-02-28 23:59:59'}
ENDWEEK 34
NAME February 2026
PERIOD 8
QUARTER 3
STARTDATE {ts '2026-02-01 00:00:00'}
STARTWEEK 31
WEEKS 4
WEEKSELAPSED 34
WEEKSREMAINING 18
9
struct
CALENDARMONTH 3
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-03-31 23:59:59'}
ENDWEEK 39
NAME March 2026
PERIOD 9
QUARTER 3
STARTDATE {ts '2026-03-01 00:00:00'}
STARTWEEK 35
WEEKS 5
WEEKSELAPSED 39
WEEKSREMAINING 13
10
struct
CALENDARMONTH 4
CALENDARYEAR 2026
DAYSINPERIOD 30
ENDDATE {ts '2026-04-30 23:59:59'}
ENDWEEK 43
NAME April 2026
PERIOD 10
QUARTER 4
STARTDATE {ts '2026-04-01 00:00:00'}
STARTWEEK 40
WEEKS 4
WEEKSELAPSED 43
WEEKSREMAINING 9
11
struct
CALENDARMONTH 5
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-05-31 23:59:59'}
ENDWEEK 47
NAME May 2026
PERIOD 11
QUARTER 4
STARTDATE {ts '2026-05-01 00:00:00'}
STARTWEEK 44
WEEKS 4
WEEKSELAPSED 47
WEEKSREMAINING 5
12
struct
CALENDARMONTH 6
CALENDARYEAR 2026
DAYSINPERIOD 30
ENDDATE {ts '2026-06-30 23:59:59'}
ENDWEEK 52
NAME June 2026
PERIOD 12
QUARTER 4
STARTDATE {ts '2026-06-01 00:00:00'}
STARTWEEK 48
WEEKS 5
WEEKSELAPSED 52
WEEKSREMAINING 0
Q1
struct
CALENDARMONTH 7,8,9
ENDDATE {ts '2025-09-30 23:59:59'}
ENDWEEK 13
NAME Q1 2026
PERIOD 1,2,3
QUARTER 1
STARTDATE {ts '2025-07-01 00:00:00'}
STARTWEEK 1
WEEKS 13
WEEKSELAPSED 13
WEEKSREMAINING 39
Q2
struct
CALENDARMONTH 10,11,12
ENDDATE {ts '2025-12-31 23:59:59'}
ENDWEEK 26
NAME Q2 2026
PERIOD 4,5,6
QUARTER 2
STARTDATE {ts '2025-10-01 00:00:00'}
STARTWEEK 14
WEEKS 13
WEEKSELAPSED 26
WEEKSREMAINING 26
Q3
struct
CALENDARMONTH 1,2,3
ENDDATE {ts '2026-03-31 23:59:59'}
ENDWEEK 39
NAME Q3 2026
PERIOD 7,8,9
QUARTER 3
STARTDATE {ts '2026-01-01 00:00:00'}
STARTWEEK 27
WEEKS 13
WEEKSELAPSED 39
WEEKSREMAINING 13
Q4
struct
CALENDARMONTH 4,5,6
ENDDATE {ts '2026-06-30 23:59:59'}
ENDWEEK 52
NAME Q4 2026
PERIOD 10,11,12
QUARTER 4
STARTDATE {ts '2026-04-01 00:00:00'}
STARTWEEK 40
WEEKS 13
WEEKSELAPSED 52
WEEKSREMAINING 0
T1
struct
CALENDARMONTH 7,8,9,10
ENDDATE {ts '2025-10-31 23:59:59'}
ENDWEEK 17
NAME First Trimester 2026
PERIOD 1,2,3,4
STARTDATE {ts '2025-07-01 00:00:00'}
STARTWEEK 1
WEEKS 17
WEEKSELAPSED 17
WEEKSREMAINING 35
T2
struct
CALENDARMONTH 11,12,1,2
ENDDATE {ts '2026-02-28 23:59:59'}
ENDWEEK 34
NAME Second Trimester 2026
PERIOD 5,6,7,8
STARTDATE {ts '2025-11-01 00:00:00'}
STARTWEEK 18
WEEKS 17
WEEKSELAPSED 34
WEEKSREMAINING 18
T3
struct
CALENDARMONTH 3,4,5,6
ENDDATE {ts '2026-06-30 23:59:59'}
ENDWEEK 52
NAME Third Trimester 2026
PERIOD 9,10,11,12
STARTDATE {ts '2026-03-01 00:00:00'}
STARTWEEK 35
WEEKS 18
WEEKSELAPSED 52
WEEKSREMAINING 0
TOTALWEEKS 52
WEEKS
array
1
struct
CALENDARMONTH 7
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-07-05 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 1
PERIOD 1
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 1
STARTDATE {ts '2025-07-01 00:00:00'}
WEEKS 4
WEEKSELAPSED 1
WEEKSREMAINING 51
2
struct
CALENDARMONTH 7
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-07-12 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 2
PERIOD 1
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 2
STARTDATE {ts '2025-07-06 00:00:00'}
WEEKS 4
WEEKSELAPSED 2
WEEKSREMAINING 50
3
struct
CALENDARMONTH 7
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-07-19 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 3
PERIOD 1
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 3
STARTDATE {ts '2025-07-13 00:00:00'}
WEEKS 4
WEEKSELAPSED 3
WEEKSREMAINING 49
4
struct
CALENDARMONTH 7
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-07-26 23:59:59'}
MONTHEND true
NAME Fiscal 2026 Week 4
PERIOD 1
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 4
STARTDATE {ts '2025-07-20 00:00:00'}
WEEKS 4
WEEKSELAPSED 4
WEEKSREMAINING 48
5
struct
CALENDARMONTH 7
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-08-02 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 5
PERIOD 1
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 5
STARTDATE {ts '2025-07-27 00:00:00'}
WEEKS 4
WEEKSELAPSED 5
WEEKSREMAINING 47
6
struct
CALENDARMONTH 8
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-08-09 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 6
PERIOD 2
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 6
STARTDATE {ts '2025-08-03 00:00:00'}
WEEKS 4
WEEKSELAPSED 6
WEEKSREMAINING 46
7
struct
CALENDARMONTH 8
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-08-16 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 7
PERIOD 2
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 7
STARTDATE {ts '2025-08-10 00:00:00'}
WEEKS 4
WEEKSELAPSED 7
WEEKSREMAINING 45
8
struct
CALENDARMONTH 8
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-08-23 23:59:59'}
MONTHEND true
NAME Fiscal 2026 Week 8
PERIOD 2
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 8
STARTDATE {ts '2025-08-17 00:00:00'}
WEEKS 4
WEEKSELAPSED 8
WEEKSREMAINING 44
9
struct
CALENDARMONTH 8
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-08-30 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 9
PERIOD 2
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 9
STARTDATE {ts '2025-08-24 00:00:00'}
WEEKS 4
WEEKSELAPSED 9
WEEKSREMAINING 43
10
struct
CALENDARMONTH 8
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-09-06 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 10
PERIOD 2
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 10
STARTDATE {ts '2025-08-31 00:00:00'}
WEEKS 4
WEEKSELAPSED 10
WEEKSREMAINING 42
11
struct
CALENDARMONTH 9
CALENDARYEAR 2025
DAYSINPERIOD 30
ENDDATE {ts '2025-09-13 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 11
PERIOD 3
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 11
STARTDATE {ts '2025-09-07 00:00:00'}
WEEKS 5
WEEKSELAPSED 11
WEEKSREMAINING 41
12
struct
CALENDARMONTH 9
CALENDARYEAR 2025
DAYSINPERIOD 30
ENDDATE {ts '2025-09-20 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 12
PERIOD 3
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 12
STARTDATE {ts '2025-09-14 00:00:00'}
WEEKS 5
WEEKSELAPSED 12
WEEKSREMAINING 40
13
struct
CALENDARMONTH 9
CALENDARYEAR 2025
DAYSINPERIOD 30
ENDDATE {ts '2025-09-27 23:59:59'}
MONTHEND true
NAME Fiscal 2026 Week 13
PERIOD 3
QUARTER Q1
QUARTEREND true
QUARTERWEEKSELAPSED 13
STARTDATE {ts '2025-09-21 00:00:00'}
WEEKS 5
WEEKSELAPSED 13
WEEKSREMAINING 39
14
struct
CALENDARMONTH 9
CALENDARYEAR 2025
DAYSINPERIOD 30
ENDDATE {ts '2025-10-04 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 14
PERIOD 3
QUARTER Q1
QUARTEREND false
QUARTERWEEKSELAPSED 14
STARTDATE {ts '2025-09-28 00:00:00'}
WEEKS 5
WEEKSELAPSED 14
WEEKSREMAINING 38
15
struct
CALENDARMONTH 10
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-10-11 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 15
PERIOD 4
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 2
STARTDATE {ts '2025-10-05 00:00:00'}
WEEKS 4
WEEKSELAPSED 15
WEEKSREMAINING 37
16
struct
CALENDARMONTH 10
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-10-18 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 16
PERIOD 4
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 3
STARTDATE {ts '2025-10-12 00:00:00'}
WEEKS 4
WEEKSELAPSED 16
WEEKSREMAINING 36
17
struct
CALENDARMONTH 10
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-10-25 23:59:59'}
MONTHEND true
NAME Fiscal 2026 Week 17
PERIOD 4
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 4
STARTDATE {ts '2025-10-19 00:00:00'}
WEEKS 4
WEEKSELAPSED 17
WEEKSREMAINING 35
18
struct
CALENDARMONTH 10
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-11-01 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 18
PERIOD 4
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 5
STARTDATE {ts '2025-10-26 00:00:00'}
WEEKS 4
WEEKSELAPSED 18
WEEKSREMAINING 34
19
struct
CALENDARMONTH 11
CALENDARYEAR 2025
DAYSINPERIOD 30
ENDDATE {ts '2025-11-08 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 19
PERIOD 5
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 6
STARTDATE {ts '2025-11-02 00:00:00'}
WEEKS 4
WEEKSELAPSED 19
WEEKSREMAINING 33
20
struct
CALENDARMONTH 11
CALENDARYEAR 2025
DAYSINPERIOD 30
ENDDATE {ts '2025-11-15 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 20
PERIOD 5
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 7
STARTDATE {ts '2025-11-09 00:00:00'}
WEEKS 4
WEEKSELAPSED 20
WEEKSREMAINING 32
21
struct
CALENDARMONTH 11
CALENDARYEAR 2025
DAYSINPERIOD 30
ENDDATE {ts '2025-11-22 23:59:59'}
MONTHEND true
NAME Fiscal 2026 Week 21
PERIOD 5
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 8
STARTDATE {ts '2025-11-16 00:00:00'}
WEEKS 4
WEEKSELAPSED 21
WEEKSREMAINING 31
22
struct
CALENDARMONTH 11
CALENDARYEAR 2025
DAYSINPERIOD 30
ENDDATE {ts '2025-11-29 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 22
PERIOD 5
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 9
STARTDATE {ts '2025-11-23 00:00:00'}
WEEKS 4
WEEKSELAPSED 22
WEEKSREMAINING 30
23
struct
CALENDARMONTH 11
CALENDARYEAR 2025
DAYSINPERIOD 30
ENDDATE {ts '2025-12-06 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 23
PERIOD 5
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 10
STARTDATE {ts '2025-11-30 00:00:00'}
WEEKS 4
WEEKSELAPSED 23
WEEKSREMAINING 29
24
struct
CALENDARMONTH 12
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-12-13 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 24
PERIOD 6
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 11
STARTDATE {ts '2025-12-07 00:00:00'}
WEEKS 5
WEEKSELAPSED 24
WEEKSREMAINING 28
25
struct
CALENDARMONTH 12
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-12-20 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 25
PERIOD 6
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 12
STARTDATE {ts '2025-12-14 00:00:00'}
WEEKS 5
WEEKSELAPSED 25
WEEKSREMAINING 27
26
struct
CALENDARMONTH 12
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2025-12-27 23:59:59'}
MONTHEND true
NAME Fiscal 2026 Week 26
PERIOD 6
QUARTER Q2
QUARTEREND true
QUARTERWEEKSELAPSED 13
STARTDATE {ts '2025-12-21 00:00:00'}
WEEKS 5
WEEKSELAPSED 26
WEEKSREMAINING 26
27
struct
CALENDARMONTH 12
CALENDARYEAR 2025
DAYSINPERIOD 31
ENDDATE {ts '2026-01-03 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 27
PERIOD 6
QUARTER Q2
QUARTEREND false
QUARTERWEEKSELAPSED 14
STARTDATE {ts '2025-12-28 00:00:00'}
WEEKS 5
WEEKSELAPSED 27
WEEKSREMAINING 25
28
struct
CALENDARMONTH 1
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-01-10 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 28
PERIOD 7
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 2
STARTDATE {ts '2026-01-04 00:00:00'}
WEEKS 4
WEEKSELAPSED 28
WEEKSREMAINING 24
29
struct
CALENDARMONTH 1
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-01-17 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 29
PERIOD 7
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 3
STARTDATE {ts '2026-01-11 00:00:00'}
WEEKS 4
WEEKSELAPSED 29
WEEKSREMAINING 23
30
struct
CALENDARMONTH 1
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-01-24 23:59:59'}
MONTHEND true
NAME Fiscal 2026 Week 30
PERIOD 7
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 4
STARTDATE {ts '2026-01-18 00:00:00'}
WEEKS 4
WEEKSELAPSED 30
WEEKSREMAINING 22
31
struct
CALENDARMONTH 1
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-01-31 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 31
PERIOD 7
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 5
STARTDATE {ts '2026-01-25 00:00:00'}
WEEKS 4
WEEKSELAPSED 31
WEEKSREMAINING 21
32
struct
CALENDARMONTH 2
CALENDARYEAR 2026
DAYSINPERIOD 28
ENDDATE {ts '2026-02-07 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 32
PERIOD 8
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 6
STARTDATE {ts '2026-02-01 00:00:00'}
WEEKS 4
WEEKSELAPSED 32
WEEKSREMAINING 20
33
struct
CALENDARMONTH 2
CALENDARYEAR 2026
DAYSINPERIOD 28
ENDDATE {ts '2026-02-14 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 33
PERIOD 8
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 7
STARTDATE {ts '2026-02-08 00:00:00'}
WEEKS 4
WEEKSELAPSED 33
WEEKSREMAINING 19
34
struct
CALENDARMONTH 2
CALENDARYEAR 2026
DAYSINPERIOD 28
ENDDATE {ts '2026-02-21 23:59:59'}
MONTHEND true
NAME Fiscal 2026 Week 34
PERIOD 8
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 8
STARTDATE {ts '2026-02-15 00:00:00'}
WEEKS 4
WEEKSELAPSED 34
WEEKSREMAINING 18
35
struct
CALENDARMONTH 2
CALENDARYEAR 2026
DAYSINPERIOD 28
ENDDATE {ts '2026-02-28 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 35
PERIOD 8
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 9
STARTDATE {ts '2026-02-22 00:00:00'}
WEEKS 4
WEEKSELAPSED 35
WEEKSREMAINING 17
36
struct
CALENDARMONTH 3
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-03-07 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 36
PERIOD 9
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 10
STARTDATE {ts '2026-03-01 00:00:00'}
WEEKS 5
WEEKSELAPSED 36
WEEKSREMAINING 16
37
struct
CALENDARMONTH 3
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-03-14 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 37
PERIOD 9
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 11
STARTDATE {ts '2026-03-08 00:00:00'}
WEEKS 5
WEEKSELAPSED 37
WEEKSREMAINING 15
38
struct
CALENDARMONTH 3
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-03-21 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 38
PERIOD 9
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 12
STARTDATE {ts '2026-03-15 00:00:00'}
WEEKS 5
WEEKSELAPSED 38
WEEKSREMAINING 14
39
struct
CALENDARMONTH 3
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-03-28 23:59:59'}
MONTHEND true
NAME Fiscal 2026 Week 39
PERIOD 9
QUARTER Q3
QUARTEREND true
QUARTERWEEKSELAPSED 13
STARTDATE {ts '2026-03-22 00:00:00'}
WEEKS 5
WEEKSELAPSED 39
WEEKSREMAINING 13
40
struct
CALENDARMONTH 3
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-04-04 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 40
PERIOD 9
QUARTER Q3
QUARTEREND false
QUARTERWEEKSELAPSED 14
STARTDATE {ts '2026-03-29 00:00:00'}
WEEKS 5
WEEKSELAPSED 40
WEEKSREMAINING 12
41
struct
CALENDARMONTH 4
CALENDARYEAR 2026
DAYSINPERIOD 30
ENDDATE {ts '2026-04-11 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 41
PERIOD 10
QUARTER Q4
QUARTEREND false
QUARTERWEEKSELAPSED 2
STARTDATE {ts '2026-04-05 00:00:00'}
WEEKS 4
WEEKSELAPSED 41
WEEKSREMAINING 11
42
struct
CALENDARMONTH 4
CALENDARYEAR 2026
DAYSINPERIOD 30
ENDDATE {ts '2026-04-18 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 42
PERIOD 10
QUARTER Q4
QUARTEREND false
QUARTERWEEKSELAPSED 3
STARTDATE {ts '2026-04-12 00:00:00'}
WEEKS 4
WEEKSELAPSED 42
WEEKSREMAINING 10
43
struct
CALENDARMONTH 4
CALENDARYEAR 2026
DAYSINPERIOD 30
ENDDATE {ts '2026-04-25 23:59:59'}
MONTHEND true
NAME Fiscal 2026 Week 43
PERIOD 10
QUARTER Q4
QUARTEREND false
QUARTERWEEKSELAPSED 4
STARTDATE {ts '2026-04-19 00:00:00'}
WEEKS 4
WEEKSELAPSED 43
WEEKSREMAINING 9
44
struct
CALENDARMONTH 4
CALENDARYEAR 2026
DAYSINPERIOD 30
ENDDATE {ts '2026-05-02 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 44
PERIOD 10
QUARTER Q4
QUARTEREND false
QUARTERWEEKSELAPSED 5
STARTDATE {ts '2026-04-26 00:00:00'}
WEEKS 4
WEEKSELAPSED 44
WEEKSREMAINING 8
45
struct
CALENDARMONTH 5
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-05-09 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 45
PERIOD 11
QUARTER Q4
QUARTEREND false
QUARTERWEEKSELAPSED 6
STARTDATE {ts '2026-05-03 00:00:00'}
WEEKS 4
WEEKSELAPSED 45
WEEKSREMAINING 7
46
struct
CALENDARMONTH 5
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-05-16 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 46
PERIOD 11
QUARTER Q4
QUARTEREND false
QUARTERWEEKSELAPSED 7
STARTDATE {ts '2026-05-10 00:00:00'}
WEEKS 4
WEEKSELAPSED 46
WEEKSREMAINING 6
47
struct
CALENDARMONTH 5
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-05-23 23:59:59'}
MONTHEND true
NAME Fiscal 2026 Week 47
PERIOD 11
QUARTER Q4
QUARTEREND false
QUARTERWEEKSELAPSED 8
STARTDATE {ts '2026-05-17 00:00:00'}
WEEKS 4
WEEKSELAPSED 47
WEEKSREMAINING 5
48
struct
CALENDARMONTH 5
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-05-30 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 48
PERIOD 11
QUARTER Q4
QUARTEREND false
QUARTERWEEKSELAPSED 9
STARTDATE {ts '2026-05-24 00:00:00'}
WEEKS 4
WEEKSELAPSED 48
WEEKSREMAINING 4
49
struct
CALENDARMONTH 5
CALENDARYEAR 2026
DAYSINPERIOD 31
ENDDATE {ts '2026-06-06 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 49
PERIOD 11
QUARTER Q4
QUARTEREND false
QUARTERWEEKSELAPSED 10
STARTDATE {ts '2026-05-31 00:00:00'}
WEEKS 4
WEEKSELAPSED 49
WEEKSREMAINING 3
50
struct
CALENDARMONTH 6
CALENDARYEAR 2026
DAYSINPERIOD 30
ENDDATE {ts '2026-06-13 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 50
PERIOD 12
QUARTER Q4
QUARTEREND false
QUARTERWEEKSELAPSED 11
STARTDATE {ts '2026-06-07 00:00:00'}
WEEKS 5
WEEKSELAPSED 50
WEEKSREMAINING 2
51
struct
CALENDARMONTH 6
CALENDARYEAR 2026
DAYSINPERIOD 30
ENDDATE {ts '2026-06-20 23:59:59'}
MONTHEND false
NAME Fiscal 2026 Week 51
PERIOD 12
QUARTER Q4
QUARTEREND false
QUARTERWEEKSELAPSED 12
STARTDATE {ts '2026-06-14 00:00:00'}
WEEKS 5
WEEKSELAPSED 51
WEEKSREMAINING 1
52
struct
CALENDARMONTH 6
CALENDARYEAR 2026
DAYSINPERIOD 30
ENDDATE {ts '2026-06-27 23:59:59'}
MONTHEND true
NAME Fiscal 2026 Week 52
PERIOD 12
QUARTER Q4
QUARTEREND true
QUARTERWEEKSELAPSED 13
STARTDATE {ts '2026-06-21 00:00:00'}
WEEKS 5
WEEKSELAPSED 52
WEEKSREMAINING 0
53
struct
CALENDARMONTH 6
CALENDARYEAR 2026
DAYSINPERIOD 30
ENDDATE {ts '2026-06-30 23:59:59'}
NAME Fiscal 2026 Week 53
PERIOD 12
QUARTER 4
STARTDATE {ts '2026-06-28 00:00:00'}
WEEKS 5
WEEKSELAPSED 53
WEEKSREMAINING -1
WEEKSELAPSED 0
Y1
struct
CALENDARMONTH 7,8,9,10,11,12,1,2,3,4,5,6
ENDDATE {ts '2026-06-30 23:59:59'}
NAME Fiscal 2026
PERIOD 1,2,3,4,5,6,7,8,9,10,11,12
STARTDATE {ts '2025-07-01 00:00:00'}
WEEKS 52
WEEKSELAPSED 52
WEEKSREMAINING 0