Manju
asked on
SQL Fiscal Calendar - Stored Procedure with Parameters
Experts -
Table: FiscalCalendarMain
Fields:
FiscalCalendarID - Autonumber in SQL
FiscalCalendarName - nvarchar(255) - User Entry comes from a web page
FiscalCalendarStartDate - smalldatetime - User Entry comes from a web page
FiscalCalendarEndDate - smalldatetime - User Entry comes from a web page
FiscalStartMonth - nvarchar(255) - User Entry comes from a web page.
User accesses a web page & posts data onto above table. Once they submit, below table should also be automatically updated via a stored procedure with the parameters from above table (FiscalStartDate, FiscalEndDate, FiscalStartMonth)
Ex:
FiscalStartDate = 11/24/2017
FiscalEndDate = 06/30/2020
FiscalStartMonth = 7
Table: FiscalCalendarDetails
Fields:
SNO - Autonumber in SQL
FiscalCalendarID - nvarchar(255) - Comes from above table
FiscalDate - Smalldatetime - Ex: 11/24/2017
FiscalDay - nvarchar(255) - Ex: 24
FiscalDayName - nvarchar(255) - Ex: Friday
FiscalMonth - nvarchar(255) - Ex: 11
FiscalMonthName - nvarchar(255) - Ex: November
IsWeekend - nvarchar(255) - Ex: 1 for weekend(from FiscalDayName for Saturday and Sunday) and 0 for Weekdays
IsHoliday - nvarchar(255) - Default value for this field is 0.
HolidayName - nvarchar(255) - Default value for this field is ""
FiscalWk - nvarchar(255) - Ex: WK01 - Week number will be decided from the FiscalStartMonth from above table
FiscalQtr - nvarchar(255) - Ex: QTR01 - Quarter number will be decided from the FiscalStartMonth from above table
FiscalYear - nvarchar(255) - Ex: 2017
FiscalYearPerCalendar - nvarchar(255) - Ex: FY1718 (with prefix "FY", 17 and 18 in the example comes from FiscalStartMonth(from previous table) and FiscalEndMonth (12 months rolling from FiscalStartMonth)
Kindly help me with an SP for the above please.
Table: FiscalCalendarMain
Fields:
FiscalCalendarID - Autonumber in SQL
FiscalCalendarName - nvarchar(255) - User Entry comes from a web page
FiscalCalendarStartDate - smalldatetime - User Entry comes from a web page
FiscalCalendarEndDate - smalldatetime - User Entry comes from a web page
FiscalStartMonth - nvarchar(255) - User Entry comes from a web page.
User accesses a web page & posts data onto above table. Once they submit, below table should also be automatically updated via a stored procedure with the parameters from above table (FiscalStartDate, FiscalEndDate, FiscalStartMonth)
Ex:
FiscalStartDate = 11/24/2017
FiscalEndDate = 06/30/2020
FiscalStartMonth = 7
Table: FiscalCalendarDetails
Fields:
SNO - Autonumber in SQL
FiscalCalendarID - nvarchar(255) - Comes from above table
FiscalDate - Smalldatetime - Ex: 11/24/2017
FiscalDay - nvarchar(255) - Ex: 24
FiscalDayName - nvarchar(255) - Ex: Friday
FiscalMonth - nvarchar(255) - Ex: 11
FiscalMonthName - nvarchar(255) - Ex: November
IsWeekend - nvarchar(255) - Ex: 1 for weekend(from FiscalDayName for Saturday and Sunday) and 0 for Weekdays
IsHoliday - nvarchar(255) - Default value for this field is 0.
HolidayName - nvarchar(255) - Default value for this field is ""
FiscalWk - nvarchar(255) - Ex: WK01 - Week number will be decided from the FiscalStartMonth from above table
FiscalQtr - nvarchar(255) - Ex: QTR01 - Quarter number will be decided from the FiscalStartMonth from above table
FiscalYear - nvarchar(255) - Ex: 2017
FiscalYearPerCalendar - nvarchar(255) - Ex: FY1718 (with prefix "FY", 17 and 18 in the example comes from FiscalStartMonth(from previous table) and FiscalEndMonth (12 months rolling from FiscalStartMonth)
Kindly help me with an SP for the above please.
You need 1 sp for both the inserts correct?
ASKER
Only for the 2nd table (FiscalCalendarDetails)
Ex:
Declare @FiscalCalendarID nvarchar(255)
Declare @FiscalStartMonth nvarchar(255)
Declare @FiscalStartDate smalldatetime
Declare @FiscalEndDate smalldatetime
Set @FiscalCalendarID = 100
Set @FiscalStartMonth = 7
Set @FiscalStartDate = '11/24/2017'
Set @FiscalEndDate = '30/06/2020'
Remaining is what am asking help for.
Ex:
Declare @FiscalCalendarID nvarchar(255)
Declare @FiscalStartMonth nvarchar(255)
Declare @FiscalStartDate smalldatetime
Declare @FiscalEndDate smalldatetime
Set @FiscalCalendarID = 100
Set @FiscalStartMonth = 7
Set @FiscalStartDate = '11/24/2017'
Set @FiscalEndDate = '30/06/2020'
Remaining is what am asking help for.
ASKER
I am able to get till here:
Main concern is trying to find the FiscalWeek, Qtr & FiscalYearpercalendar. Please help.
DECLARE @StartDate smalldatetime = '11/01/2017' --First Calendar date to include in table
DECLARE @EndDate smalldatetime = '06/30/2020' --Last calendar date to include in the table
declare @FiscalYearBegin_First smalldatetime = '07/01/2017' -- Considering 7 comes as FiscalStartMonth
DECLARE @Cycle INT = 52
SET DATEFIRST 7
;WITH --This secton generates the number table
E00(N) AS (SELECT 1 UNION ALL SELECT 1),
E02(N) AS (SELECT 1 FROM E00 a, E00 b),
E04(N) AS (SELECT 1 FROM E02 a, E02 b),
E08(N) AS (SELECT 1 FROM E04 a, E04 b),
E16(N) AS (SELECT 1 FROM E08 a, E08 b),
E32(N) AS (SELECT 1 FROM E16 a, E16 b),
cteTally(N) AS (SELECT ROW_NUMBER() OVER (ORDER BY N) FROM E32),
--This CTE generates a list of calendar dates
CalendarBase as (
SELECT
DateKey = n
, FiscalDate = DATEADD(day, n -1, @StartDate )
, case when n = 1 then @FiscalYearBegin_First
else
case when datepart(dw,DATEADD(DAY, n -1 , @StartDate )) = 2 then dateadd(week,CAST(ABS(DATEDIFF(WEEK,DATEADD(day, n -1 , @StartDate ),@StartDate))/@Cycle AS INT) * @Cycle,@FiscalYearBegin_First)
else
dateadd(week, datediff(week, 0, dateadd(week,CAST(ABS(DATEDIFF(WEEK,DATEADD(day, n - 1, @StartDate ),@StartDate))/@Cycle AS INT) * @Cycle,@FiscalYearBegin_First)), 7)
end
end FiscalYearBegin
FROM cteTally
WHERE N <= DATEDIFF(day, @StartDate , @EndDate +1)
)
--Finally, use the list of calendar dates to fill the date dimension
SELECT DateKey as SNO
, '100' as 'FiscalCalendarID'
, FiscalDate
, FiscalDay = DATEPART(DAY, FiscalDate)
, FiscalDayName = DATENAME (Weekday,FiscalDate )
, FiscalMonth = MONTH(FiscalDate)
, FiscalMonthName = DATENAME(Month, FiscalDate)
, Case when (DATENAME (Weekday,FiscalDate)) in ('Saturday', 'Sunday') Then 1 Else 0 End as IsWeekend
, 'IsHoliday' = 0
, 'HolidayName' = 'No'
, FiscalWeek = 'WK'
, FiscalQtr = 'QTR'
, FiscalYear = YEAR(FiscalDate)
, FiscalYearPerCalendar = 'FY'
FROM CalendarBase
Main concern is trying to find the FiscalWeek, Qtr & FiscalYearpercalendar. Please help.
Please try this -
, FiscalWeek = 'WK' + RIGHT('0' + CAST ( DAY(FiscalDate) AS VARCHAR ),2)
, FiscalQtr = 'QTR' + + RIGHT('0' + CAST ( DATEPART(QUARTER, FiscalDate) AS VARCHAR ),2)
, FiscalYearPerCalendar = 'FY' + CAST(RIGHT(FiscalDate,2) AS VARCHAR) + CAST( ( CAST(RIGHT(FiscalDate,2)AS INT) + 1 ) AS VARCHAR)
First of all: is this a relational or dimensional table?
ASKER
@Pawan - Nope, its not working correctly.
As you can see in the attached picture,
WK is getting as "WK " + day. This is not what i want.
Similarly, QTR is not correct.
What i want is, considering FIscalStartMonth is 7
I want July to be the start of fiscal.
So, First 4 week's of July should be WK 01 to WK 04 and Quarter should be QTR 1 till September end.
and Last column of FiscalYearperCalendar is throwing up error.
As you can see in the attached picture,
WK is getting as "WK " + day. This is not what i want.
Similarly, QTR is not correct.
What i want is, considering FIscalStartMonth is 7
I want July to be the start of fiscal.
So, First 4 week's of July should be WK 01 to WK 04 and Quarter should be QTR 1 till September end.
and Last column of FiscalYearperCalendar is throwing up error.
ASKER
I changed the last column as below to get the value but still its not correct value.
, FiscalYearPerCalendar = 'FY ' + CAST(RIGHT(Year(FiscalDate ),2) AS VARCHAR) + CAST( ( CAST(RIGHT(year(FiscalDate ),2)AS INT) + 1 ) AS VARCHAR)
, FiscalYearPerCalendar = 'FY ' + CAST(RIGHT(Year(FiscalDate
changing.
Please try full tested solution for you-
OUTPUT
DECLARE @StartDate smalldatetime = '11/01/2017' --First Calendar date to include in table
DECLARE @EndDate smalldatetime = '06/30/2020' --Last calendar date to include in the table
declare @FiscalYearBegin_First smalldatetime = '07/01/2017' -- Considering 7 comes as FiscalStartMonth
DECLARE @Cycle INT = 52
SET DATEFIRST 7 ;
;WITH SingleDigits(Number) AS
(
SELECT Number
FROM (VALUES (1), (2), (3), (4), (5), (6), (7), (8),
(9), (0)) AS X(Number)
)
,Series AS
(
SELECT (d1.Number+1) + (10*d2.Number) + (100*d3.Number) + (1000*d4.Number) Number
from
SingleDigits as d1,
SingleDigits as d2,
SingleDigits as d3,
SingleDigits as d4
)
,CTE1 AS
(
SELECT Number datekey, DATEADD(Day,Number-1,@StartDate) FiscalDate
, case when Number = 1 then @FiscalYearBegin_First
else
case when datepart(dw,DATEADD(DAY, number -1 , @StartDate )) = 2 then dateadd(week,CAST(ABS(DATEDIFF(WEEK,DATEADD(day, number -1 , @StartDate ),@StartDate))/@Cycle AS INT) * @Cycle,@FiscalYearBegin_First)
else
dateadd(week, datediff(week, 0, dateadd(week,CAST(ABS(DATEDIFF(WEEK,DATEADD(day, number - 1, @StartDate ),@StartDate))/@Cycle AS INT) * @Cycle,@FiscalYearBegin_First)), 7)
end
END FiscalYearBegin
FROM Series
WHERE DATEADD(Day,Number-1,@StartDate) <= @EndDate
)
SELECT DateKey as SNO
, '100' as 'FiscalCalendarID'
, FiscalDate
, FiscalDay = DATEPART(DAY, FiscalDate)
, FiscalDayName = DATENAME (Weekday,FiscalDate )
, FiscalMonth = MONTH(FiscalDate)
, FiscalMonthName = DATENAME(Month, FiscalDate)
, Case when (DATENAME (Weekday,FiscalDate)) in ('Saturday', 'Sunday') Then 1 Else 0 End as IsWeekend
, 'IsHoliday' = 0
, 'HolidayName' = 'No'
, FiscalWeek = CONCAT( 'WK'
, CASE WHEN DATEPART(DAY, FiscalDate) < 8 THEN '01'
WHEN DATEPART(DAY, FiscalDate) >= 8 AND DATEPART(DAY, FiscalDate) < 15 THEN '02'
WHEN DATEPART(DAY, FiscalDate) >= 15 AND DATEPART(DAY, FiscalDate) < 22 THEN '03'
WHEN DATEPART(DAY, FiscalDate) >= 22 AND DATEPART(DAY, FiscalDate) <= 30 THEN '04'
END )
, FiscalQtr = CONCAT( 'QTR' ,
CASE WHEN FiscalDate BETWEEN @FiscalYearBegin_First AND DATEADD(month,3,@FiscalYearBegin_First) THEN '01'
WHEN FiscalDate BETWEEN @FiscalYearBegin_First AND DATEADD(month,6,@FiscalYearBegin_First) THEN '02'
WHEN FiscalDate BETWEEN @FiscalYearBegin_First AND DATEADD(month,9,@FiscalYearBegin_First) THEN '03'
WHEN FiscalDate BETWEEN @FiscalYearBegin_First AND DATEADD(month,12,@FiscalYearBegin_First) THEN '04' END )
, FiscalYear = YEAR(FiscalDate)
, FiscalYearPerCalendar = CONCAT( 'FY', CAST(RIGHT(Year(FiscalDate),2) AS VARCHAR) , CAST( ( CAST(RIGHT(year(FiscalDate),2)AS INT) + 1 ) AS VARCHAR) )
FROM CTE1
ORDER BY datekey
OUTPUT
/*------------------------
OUTPUT
------------------------*/
SNO FiscalCalendarID FiscalDate FiscalDay FiscalDayName FiscalMonth FiscalMonthName IsWeekend IsHoliday HolidayName FiscalWeek FiscalQtr FiscalYear FiscalYearPerCalendar
----------- ---------------- ----------------------- ----------- ------------------------------ ----------- ------------------------------ ----------- ----------- ----------- ---------- --------- ----------- --------------------------------------------------------------
1 100 2017-11-01 00:00:00 1 Wednesday 11 November 0 0 No WK01 QTR02 2017 FY1718
2 100 2017-11-02 00:00:00 2 Thursday 11 November 0 0 No WK01 QTR02 2017 FY1718
3 100 2017-11-03 00:00:00 3 Friday 11 November 0 0 No WK01 QTR02 2017 FY1718
4 100 2017-11-04 00:00:00 4 Saturday 11 November 1 0 No WK01 QTR02 2017 FY1718
5 100 2017-11-05 00:00:00 5 Sunday 11 November 1 0 No WK01 QTR02 2017 FY1718
6 100 2017-11-06 00:00:00 6 Monday 11 November 0 0 No WK01 QTR02 2017 FY1718
7 100 2017-11-07 00:00:00 7 Tuesday 11 November 0 0 No WK01 QTR02 2017 FY1718
8 100 2017-11-08 00:00:00 8 Wednesday 11 November 0 0 No WK02 QTR02 2017 FY1718
9 100 2017-11-09 00:00:00 9 Thursday 11 November 0 0 No WK02 QTR02 2017 FY1718
10 100 2017-11-10 00:00:00 10 Friday 11 November 0 0 No WK02 QTR02 2017 FY1718
11 100 2017-11-11 00:00:00 11 Saturday 11 November 1 0 No WK02 QTR02 2017 FY1718
12 100 2017-11-12 00:00:00 12 Sunday 11 November 1 0 No WK02 QTR02 2017 FY1718
13 100 2017-11-13 00:00:00 13 Monday 11 November 0 0 No WK02 QTR02 2017 FY1718
14 100 2017-11-14 00:00:00 14 Tuesday 11 November 0 0 No WK02 QTR02 2017 FY1718
15 100 2017-11-15 00:00:00 15 Wednesday 11 November 0 0 No WK03 QTR02 2017 FY1718
16 100 2017-11-16 00:00:00 16 Thursday 11 November 0 0 No WK03 QTR02 2017 FY1718
17 100 2017-11-17 00:00:00 17 Friday 11 November 0 0 No WK03 QTR02 2017 FY1718
18 100 2017-11-18 00:00:00 18 Saturday 11 November 1 0 No WK03 QTR02 2017 FY1718
19 100 2017-11-19 00:00:00 19 Sunday 11 November 1 0 No WK03 QTR02 2017 FY1718
20 100 2017-11-20 00:00:00 20 Monday 11 November 0 0 No WK03 QTR02 2017 FY1718
21 100 2017-11-21 00:00:00 21 Tuesday 11 November 0 0 No WK03 QTR02 2017 FY1718
22 100 2017-11-22 00:00:00 22 Wednesday 11 November 0 0 No WK04 QTR02 2017 FY1718
23 100 2017-11-23 00:00:00 23 Thursday 11 November 0 0 No WK04 QTR02 2017 FY1718
24 100 2017-11-24 00:00:00 24 Friday 11 November 0 0 No WK04 QTR02 2017 FY1718
25 100 2017-11-25 00:00:00 25 Saturday 11 November 1 0 No WK04 QTR02 2017 FY1718
26 100 2017-11-26 00:00:00 26 Sunday 11 November 1 0 No WK04 QTR02 2017 FY1718
27 100 2017-11-27 00:00:00 27 Monday 11 November 0 0 No WK04 QTR02 2017 FY1718
28 100 2017-11-28 00:00:00 28 Tuesday 11 November 0 0 No WK04 QTR02 2017 FY1718
29 100 2017-11-29 00:00:00 29 Wednesday 11 November 0 0 No WK04 QTR02 2017 FY1718
30 100 2017-11-30 00:00:00 30 Thursday 11 November 0 0 No WK04 QTR02 2017 FY1718
31 100 2017-12-01 00:00:00 1 Friday 12 December 0 0 No WK01 QTR02 2017 FY1718
32 100 2017-12-02 00:00:00 2 Saturday 12 December 1 0 No WK01 QTR02 2017 FY1718
33 100 2017-12-03 00:00:00 3 Sunday 12 December 1 0 No WK01 QTR02 2017 FY1718
34 100 2017-12-04 00:00:00 4 Monday 12 December 0 0 No WK01 QTR02 2017 FY1718
35 100 2017-12-05 00:00:00 5 Tuesday 12 December 0 0 No WK01 QTR02 2017 FY1718
36 100 2017-12-06 00:00:00 6 Wednesday 12 December 0 0 No WK01 QTR02 2017 FY1718
37 100 2017-12-07 00:00:00 7 Thursday 12 December 0 0 No WK01 QTR02 2017 FY1718
38 100 2017-12-08 00:00:00 8 Friday 12 December 0 0 No WK02 QTR02 2017 FY1718
39 100 2017-12-09 00:00:00 9 Saturday 12 December 1 0 No WK02 QTR02 2017 FY1718
40 100 2017-12-10 00:00:00 10 Sunday 12 December 1 0 No WK02 QTR02 2017 FY1718
41 100 2017-12-11 00:00:00 11 Monday 12 December 0 0 No WK02 QTR02 2017 FY1718
42 100 2017-12-12 00:00:00 12 Tuesday 12 December 0 0 No WK02 QTR02 2017 FY1718
43 100 2017-12-13 00:00:00 13 Wednesday 12 December 0 0 No WK02 QTR02 2017 FY1718
44 100 2017-12-14 00:00:00 14 Thursday 12 December 0 0 No WK02 QTR02 2017 FY1718
45 100 2017-12-15 00:00:00 15 Friday 12 December 0 0 No WK03 QTR02 2017 FY1718
46 100 2017-12-16 00:00:00 16 Saturday 12 December 1 0 No WK03 QTR02 2017 FY1718
47 100 2017-12-17 00:00:00 17 Sunday 12 December 1 0 No WK03 QTR02 2017 FY1718
48 100 2017-12-18 00:00:00 18 Monday 12 December 0 0 No WK03 QTR02 2017 FY1718
49 100 2017-12-19 00:00:00 19 Tuesday 12 December 0 0 No WK03 QTR02 2017 FY1718
50 100 2017-12-20 00:00:00 20 Wednesday 12 December 0 0 No WK03 QTR02 2017 FY1718
51 100 2017-12-21 00:00:00 21 Thursday 12 December 0 0 No WK03 QTR02 2017 FY1718
52 100 2017-12-22 00:00:00 22 Friday 12 December 0 0 No WK04 QTR02 2017 FY1718
53 100 2017-12-23 00:00:00 23 Saturday 12 December 1 0 No WK04 QTR02 2017 FY1718
54 100 2017-12-24 00:00:00 24 Sunday 12 December 1 0 No WK04 QTR02 2017 FY1718
55 100 2017-12-25 00:00:00 25 Monday 12 December 0 0 No WK04 QTR02 2017 FY1718
56 100 2017-12-26 00:00:00 26 Tuesday 12 December 0 0 No WK04 QTR02 2017 FY1718
57 100 2017-12-27 00:00:00 27 Wednesday 12 December 0 0 No WK04 QTR02 2017 FY1718
58 100 2017-12-28 00:00:00 28 Thursday 12 December 0 0 No WK04 QTR02 2017 FY1718
59 100 2017-12-29 00:00:00 29 Friday 12 December 0 0 No WK04 QTR02 2017 FY1718
60 100 2017-12-30 00:00:00 30 Saturday 12 December 1 0 No WK04 QTR02 2017 FY1718
61 100 2017-12-31 00:00:00 31 Sunday 12 December 1 0 No WK QTR02 2017 FY1718
62 100 2018-01-01 00:00:00 1 Monday 1 January 0 0 No WK01 QTR02 2018 FY1819
63 100 2018-01-02 00:00:00 2 Tuesday 1 January 0 0 No WK01 QTR03 2018 FY1819
64 100 2018-01-03 00:00:00 3 Wednesday 1 January 0 0 No WK01 QTR03 2018 FY1819
65 100 2018-01-04 00:00:00 4 Thursday 1 January 0 0 No WK01 QTR03 2018 FY1819
66 100 2018-01-05 00:00:00 5 Friday 1 January 0 0 No WK01 QTR03 2018 FY1819
67 100 2018-01-06 00:00:00 6 Saturday 1 January 1 0 No WK01 QTR03 2018 FY1819
68 100 2018-01-07 00:00:00 7 Sunday 1 January 1 0 No WK01 QTR03 2018 FY1819
69 100 2018-01-08 00:00:00 8 Monday 1 January 0 0 No WK02 QTR03 2018 FY1819
70 100 2018-01-09 00:00:00 9 Tuesday 1 January 0 0 No WK02 QTR03 2018 FY1819
71 100 2018-01-10 00:00:00 10 Wednesday 1 January 0 0 No WK02 QTR03 2018 FY1819
72 100 2018-01-11 00:00:00 11 Thursday 1 January 0 0 No WK02 QTR03 2018 FY1819
73 100 2018-01-12 00:00:00 12 Friday 1 January 0 0 No WK02 QTR03 2018 FY1819
74 100 2018-01-13 00:00:00 13 Saturday 1 January 1 0 No WK02 QTR03 2018 FY1819
75 100 2018-01-14 00:00:00 14 Sunday 1 January 1 0 No WK02 QTR03 2018 FY1819
76 100 2018-01-15 00:00:00 15 Monday 1 January 0 0 No WK03 QTR03 2018 FY1819
77 100 2018-01-16 00:00:00 16 Tuesday 1 January 0 0 No WK03 QTR03 2018 FY1819
78 100 2018-01-17 00:00:00 17 Wednesday 1 January 0 0 No WK03 QTR03 2018 FY1819
79 100 2018-01-18 00:00:00 18 Thursday 1 January 0 0 No WK03 QTR03 2018 FY1819
80 100 2018-01-19 00:00:00 19 Friday 1 January 0 0 No WK03 QTR03 2018 FY1819
81 100 2018-01-20 00:00:00 20 Saturday 1 January 1 0 No WK03 QTR03 2018 FY1819
82 100 2018-01-21 00:00:00 21 Sunday 1 January 1 0 No WK03 QTR03 2018 FY1819
83 100 2018-01-22 00:00:00 22 Monday 1 January 0 0 No WK04 QTR03 2018 FY1819
84 100 2018-01-23 00:00:00 23 Tuesday 1 January 0 0 No WK04 QTR03 2018 FY1819
85 100 2018-01-24 00:00:00 24 Wednesday 1 January 0 0 No WK04 QTR03 2018 FY1819
86 100 2018-01-25 00:00:00 25 Thursday 1 January 0 0 No WK04 QTR03 2018 FY1819
87 100 2018-01-26 00:00:00 26 Friday 1 January 0 0 No WK04 QTR03 2018 FY1819
88 100 2018-01-27 00:00:00 27 Saturday 1 January 1 0 No WK04 QTR03 2018 FY1819
89 100 2018-01-28 00:00:00 28 Sunday 1 January 1 0 No WK04 QTR03 2018 FY1819
90 100 2018-01-29 00:00:00 29 Monday 1 January 0 0 No WK04 QTR03 2018 FY1819
91 100 2018-01-30 00:00:00 30 Tuesday 1 January 0 0 No WK04 QTR03 2018 FY1819
92 100 2018-01-31 00:00:00 31 Wednesday 1 January 0 0 No WK QTR03 2018 FY1819
93 100 2018-02-01 00:00:00 1 Thursday 2 February 0 0 No WK01 QTR03 2018 FY1819
94 100 2018-02-02 00:00:00 2 Friday 2 February 0 0 No WK01 QTR03 2018 FY1819
95 100 2018-02-03 00:00:00 3 Saturday 2 February 1 0 No WK01 QTR03 2018 FY1819
96 100 2018-02-04 00:00:00 4 Sunday 2 February 1 0 No WK01 QTR03 2018 FY1819
97 100 2018-02-05 00:00:00 5 Monday 2 February 0 0 No WK01 QTR03 2018 FY1819
98 100 2018-02-06 00:00:00 6 Tuesday 2 February 0 0 No WK01 QTR03 2018 FY1819
99 100 2018-02-07 00:00:00 7 Wednesday 2 February 0 0 No WK01 QTR03 2018 FY1819
100 100 2018-02-08 00:00:00 8 Thursday 2 February 0 0 No WK02 QTR03 2018 FY1819
101 100 2018-02-09 00:00:00 9 Friday 2 February 0 0 No WK02 QTR03 2018 FY1819
102 100 2018-02-10 00:00:00 10 Saturday 2 February 1 0 No WK02 QTR03 2018 FY1819
103 100 2018-02-11 00:00:00 11 Sunday 2 February 1 0 No WK02 QTR03 2018 FY1819
104 100 2018-02-12 00:00:00 12 Monday 2 February 0 0 No WK02 QTR03 2018 FY1819
105 100 2018-02-13 00:00:00 13 Tuesday 2 February 0 0 No WK02 QTR03 2018 FY1819
106 100 2018-02-14 00:00:00 14 Wednesday 2 February 0 0 No WK02 QTR03 2018 FY1819
107 100 2018-02-15 00:00:00 15 Thursday 2 February 0 0 No WK03 QTR03 2018 FY1819
108 100 2018-02-16 00:00:00 16 Friday 2 February 0 0 No WK03 QTR03 2018 FY1819
109 100 2018-02-17 00:00:00 17 Saturday 2 February 1 0 No WK03 QTR03 2018 FY1819
110 100 2018-02-18 00:00:00 18 Sunday 2 February 1 0 No WK03 QTR03 2018 FY1819
111 100 2018-02-19 00:00:00 19 Monday 2 February 0 0 No WK03 QTR03 2018 FY1819
112 100 2018-02-20 00:00:00 20 Tuesday 2 February 0 0 No WK03 QTR03 2018 FY1819
113 100 2018-02-21 00:00:00 21 Wednesday 2 February 0 0 No WK03 QTR03 2018 FY1819
114 100 2018-02-22 00:00:00 22 Thursday 2 February 0 0 No WK04 QTR03 2018 FY1819
115 100 2018-02-23 00:00:00 23 Friday 2 February 0 0 No WK04 QTR03 2018 FY1819
116 100 2018-02-24 00:00:00 24 Saturday 2 February 1 0 No WK04 QTR03 2018 FY1819
117 100 2018-02-25 00:00:00 25 Sunday 2 February 1 0 No WK04 QTR03 2018 FY1819
118 100 2018-02-26 00:00:00 26 Monday 2 February 0 0 No WK04 QTR03 2018 FY1819
119 100 2018-02-27 00:00:00 27 Tuesday 2 February 0 0 No WK04 QTR03 2018 FY1819
120 100 2018-02-28 00:00:00 28 Wednesday 2 February 0 0 No WK04 QTR03 2018 FY1819
121 100 2018-03-01 00:00:00 1 Thursday 3 March 0 0 No WK01 QTR03 2018 FY1819
122 100 2018-03-02 00:00:00 2 Friday 3 March 0 0 No WK01 QTR03 2018 FY1819
123 100 2018-03-03 00:00:00 3 Saturday 3 March 1 0 No WK01 QTR03 2018 FY1819
124 100 2018-03-04 00:00:00 4 Sunday 3 March 1 0 No WK01 QTR03 2018 FY1819
125 100 2018-03-05 00:00:00 5 Monday 3 March 0 0 No WK01 QTR03 2018 FY1819
126 100 2018-03-06 00:00:00 6 Tuesday 3 March 0 0 No WK01 QTR03 2018 FY1819
127 100 2018-03-07 00:00:00 7 Wednesday 3 March 0 0 No WK01 QTR03 2018 FY1819
128 100 2018-03-08 00:00:00 8 Thursday 3 March 0 0 No WK02 QTR03 2018 FY1819
129 100 2018-03-09 00:00:00 9 Friday 3 March 0 0 No WK02 QTR03 2018 FY1819
130 100 2018-03-10 00:00:00 10 Saturday 3 March 1 0 No WK02 QTR03 2018 FY1819
131 100 2018-03-11 00:00:00 11 Sunday 3 March 1 0 No WK02 QTR03 2018 FY1819
132 100 2018-03-12 00:00:00 12 Monday 3 March 0 0 No WK02 QTR03 2018 FY1819
133 100 2018-03-13 00:00:00 13 Tuesday 3 March 0 0 No WK02 QTR03 2018 FY1819
134 100 2018-03-14 00:00:00 14 Wednesday 3 March 0 0 No WK02 QTR03 2018 FY1819
135 100 2018-03-15 00:00:00 15 Thursday 3 March 0 0 No WK03 QTR03 2018 FY1819
136 100 2018-03-16 00:00:00 16 Friday 3 March 0 0 No WK03 QTR03 2018 FY1819
137 100 2018-03-17 00:00:00 17 Saturday 3 March 1 0 No WK03 QTR03 2018 FY1819
138 100 2018-03-18 00:00:00 18 Sunday 3 March 1 0 No WK03 QTR03 2018 FY1819
139 100 2018-03-19 00:00:00 19 Monday 3 March 0 0 No WK03 QTR03 2018 FY1819
140 100 2018-03-20 00:00:00 20 Tuesday 3 March 0 0 No WK03 QTR03 2018 FY1819
141 100 2018-03-21 00:00:00 21 Wednesday 3 March 0 0 No WK03 QTR03 2018 FY1819
142 100 2018-03-22 00:00:00 22 Thursday 3 March 0 0 No WK04 QTR03 2018 FY1819
143 100 2018-03-23 00:00:00 23 Friday 3 March 0 0 No WK04 QTR03 2018 FY1819
144 100 2018-03-24 00:00:00 24 Saturday 3 March 1 0 No WK04 QTR03 2018 FY1819
145 100 2018-03-25 00:00:00 25 Sunday 3 March 1 0 No WK04 QTR03 2018 FY1819
146 100 2018-03-26 00:00:00 26 Monday 3 March 0 0 No WK04 QTR03 2018 FY1819
147 100 2018-03-27 00:00:00 27 Tuesday 3 March 0 0 No WK04 QTR03 2018 FY1819
148 100 2018-03-28 00:00:00 28 Wednesday 3 March 0 0 No WK04 QTR03 2018 FY1819
149 100 2018-03-29 00:00:00 29 Thursday 3 March 0 0 No WK04 QTR03 2018 FY1819
150 100 2018-03-30 00:00:00 30 Friday 3 March 0 0 No WK04 QTR03 2018 FY1819
151 100 2018-03-31 00:00:00 31 Saturday 3 March 1 0 No WK QTR03 2018 FY1819
152 100 2018-04-01 00:00:00 1 Sunday 4 April 1 0 No WK01 QTR03 2018 FY1819
153 100 2018-04-02 00:00:00 2 Monday 4 April 0 0 No WK01 QTR04 2018 FY1819
154 100 2018-04-03 00:00:00 3 Tuesday 4 April 0 0 No WK01 QTR04 2018 FY1819
155 100 2018-04-04 00:00:00 4 Wednesday 4 April 0 0 No WK01 QTR04 2018 FY1819
156 100 2018-04-05 00:00:00 5 Thursday 4 April 0 0 No WK01 QTR04 2018 FY1819
157 100 2018-04-06 00:00:00 6 Friday 4 April 0 0 No WK01 QTR04 2018 FY1819
158 100 2018-04-07 00:00:00 7 Saturday 4 April 1 0 No WK01 QTR04 2018 FY1819
159 100 2018-04-08 00:00:00 8 Sunday 4 April 1 0 No WK02 QTR04 2018 FY1819
160 100 2018-04-09 00:00:00 9 Monday 4 April 0 0 No WK02 QTR04 2018 FY1819
161 100 2018-04-10 00:00:00 10 Tuesday 4 April 0 0 No WK02 QTR04 2018 FY1819
162 100 2018-04-11 00:00:00 11 Wednesday 4 April 0 0 No WK02 QTR04 2018 FY1819
163 100 2018-04-12 00:00:00 12 Thursday 4 April 0 0 No WK02 QTR04 2018 FY1819
164 100 2018-04-13 00:00:00 13 Friday 4 April 0 0 No WK02 QTR04 2018 FY1819
165 100 2018-04-14 00:00:00 14 Saturday 4 April 1 0 No WK02 QTR04 2018 FY1819
166 100 2018-04-15 00:00:00 15 Sunday 4 April 1 0 No WK03 QTR04 2018 FY1819
167 100 2018-04-16 00:00:00 16 Monday 4 April 0 0 No WK03 QTR04 2018 FY1819
168 100 2018-04-17 00:00:00 17 Tuesday 4 April 0 0 No WK03 QTR04 2018 FY1819
169 100 2018-04-18 00:00:00 18 Wednesday 4 April 0 0 No WK03 QTR04 2018 FY1819
170 100 2018-04-19 00:00:00 19 Thursday 4 April 0 0 No WK03 QTR04 2018 FY1819
171 100 2018-04-20 00:00:00 20 Friday 4 April 0 0 No WK03 QTR04 2018 FY1819
172 100 2018-04-21 00:00:00 21 Saturday 4 April 1 0 No WK03 QTR04 2018 FY1819
173 100 2018-04-22 00:00:00 22 Sunday 4 April 1 0 No WK04 QTR04 2018 FY1819
174 100 2018-04-23 00:00:00 23 Monday 4 April 0 0 No WK04 QTR04 2018 FY1819
175 100 2018-04-24 00:00:00 24 Tuesday 4 April 0 0 No WK04 QTR04 2018 FY1819
176 100 2018-04-25 00:00:00 25 Wednesday 4 April 0 0 No WK04 QTR04 2018 FY1819
177 100 2018-04-26 00:00:00 26 Thursday 4 April 0 0 No WK04 QTR04 2018 FY1819
178 100 2018-04-27 00:00:00 27 Friday 4 April 0 0 No WK04 QTR04 2018 FY1819
179 100 2018-04-28 00:00:00 28 Saturday 4 April 1 0 No WK04 QTR04 2018 FY1819
180 100 2018-04-29 00:00:00 29 Sunday 4 April 1 0 No WK04 QTR04 2018 FY1819
181 100 2018-04-30 00:00:00 30 Monday 4 April 0 0 No WK04 QTR04 2018 FY1819
182 100 2018-05-01 00:00:00 1 Tuesday 5 May 0 0 No WK01 QTR04 2018 FY1819
183 100 2018-05-02 00:00:00 2 Wednesday 5 May 0 0 No WK01 QTR04 2018 FY1819
184 100 2018-05-03 00:00:00 3 Thursday 5 May 0 0 No WK01 QTR04 2018 FY1819
185 100 2018-05-04 00:00:00 4 Friday 5 May 0 0 No WK01 QTR04 2018 FY1819
186 100 2018-05-05 00:00:00 5 Saturday 5 May 1 0 No WK01 QTR04 2018 FY1819
187 100 2018-05-06 00:00:00 6 Sunday 5 May 1 0 No WK01 QTR04 2018 FY1819
188 100 2018-05-07 00:00:00 7 Monday 5 May 0 0 No WK01 QTR04 2018 FY1819
189 100 2018-05-08 00:00:00 8 Tuesday 5 May 0 0 No WK02 QTR04 2018 FY1819
190 100 2018-05-09 00:00:00 9 Wednesday 5 May 0 0 No WK02 QTR04 2018 FY1819
191 100 2018-05-10 00:00:00 10 Thursday 5 May 0 0 No WK02 QTR04 2018 FY1819
192 100 2018-05-11 00:00:00 11 Friday 5 May 0 0 No WK02 QTR04 2018 FY1819
193 100 2018-05-12 00:00:00 12 Saturday 5 May 1 0 No WK02 QTR04 2018 FY1819
194 100 2018-05-13 00:00:00 13 Sunday 5 May 1 0 No WK02 QTR04 2018 FY1819
195 100 2018-05-14 00:00:00 14 Monday 5 May 0 0 No WK02 QTR04 2018 FY1819
196 100 2018-05-15 00:00:00 15 Tuesday 5 May 0 0 No WK03 QTR04 2018 FY1819
197 100 2018-05-16 00:00:00 16 Wednesday 5 May 0 0 No WK03 QTR04 2018 FY1819
198 100 2018-05-17 00:00:00 17 Thursday 5 May 0 0 No WK03 QTR04 2018 FY1819
199 100 2018-05-18 00:00:00 18 Friday 5 May 0 0 No WK03 QTR04 2018 FY1819
200 100 2018-05-19 00:00:00 19 Saturday 5 May 1 0 No WK03 QTR04 2018 FY1819
201 100 2018-05-20 00:00:00 20 Sunday 5 May 1 0 No WK03 QTR04 2018 FY1819
202 100 2018-05-21 00:00:00 21 Monday 5 May 0 0 No WK03 QTR04 2018 FY1819
203 100 2018-05-22 00:00:00 22 Tuesday 5 May 0 0 No WK04 QTR04 2018 FY1819
204 100 2018-05-23 00:00:00 23 Wednesday 5 May 0 0 No WK04 QTR04 2018 FY1819
205 100 2018-05-24 00:00:00 24 Thursday 5 May 0 0 No WK04 QTR04 2018 FY1819
206 100 2018-05-25 00:00:00 25 Friday 5 May 0 0 No WK04 QTR04 2018 FY1819
207 100 2018-05-26 00:00:00 26 Saturday 5 May 1 0 No WK04 QTR04 2018 FY1819
208 100 2018-05-27 00:00:00 27 Sunday 5 May 1 0 No WK04 QTR04 2018 FY1819
209 100 2018-05-28 00:00:00 28 Monday 5 May 0 0 No WK04 QTR04 2018 FY1819
210 100 2018-05-29 00:00:00 29 Tuesday 5 May 0 0 No WK04 QTR04 2018 FY1819
211 100 2018-05-30 00:00:00 30 Wednesday 5 May 0 0 No WK04 QTR04 2018 FY1819
212 100 2018-05-31 00:00:00 31 Thursday 5 May 0 0 No WK QTR04 2018 FY1819
213 100 2018-06-01 00:00:00 1 Friday 6 June 0 0 No WK01 QTR04 2018 FY1819
214 100 2018-06-02 00:00:00 2 Saturday 6 June 1 0 No WK01 QTR04 2018 FY1819
215 100 2018-06-03 00:00:00 3 Sunday 6 June 1 0 No WK01 QTR04 2018 FY1819
216 100 2018-06-04 00:00:00 4 Monday 6 June 0 0 No WK01 QTR04 2018 FY1819
217 100 2018-06-05 00:00:00 5 Tuesday 6 June 0 0 No WK01 QTR04 2018 FY1819
218 100 2018-06-06 00:00:00 6 Wednesday 6 June 0 0 No WK01 QTR04 2018 FY1819
219 100 2018-06-07 00:00:00 7 Thursday 6 June 0 0 No WK01 QTR04 2018 FY1819
220 100 2018-06-08 00:00:00 8 Friday 6 June 0 0 No WK02 QTR04 2018 FY1819
221 100 2018-06-09 00:00:00 9 Saturday 6 June 1 0 No WK02 QTR04 2018 FY1819
222 100 2018-06-10 00:00:00 10 Sunday 6 June 1 0 No WK02 QTR04 2018 FY1819
223 100 2018-06-11 00:00:00 11 Monday 6 June 0 0 No WK02 QTR04 2018 FY1819
224 100 2018-06-12 00:00:00 12 Tuesday 6 June 0 0 No WK02 QTR04 2018 FY1819
225 100 2018-06-13 00:00:00 13 Wednesday 6 June 0 0 No WK02 QTR04 2018 FY1819
226 100 2018-06-14 00:00:00 14 Thursday 6 June 0 0 No WK02 QTR04 2018 FY1819
227 100 2018-06-15 00:00:00 15 Friday 6 June 0 0 No WK03 QTR04 2018 FY1819
228 100 2018-06-16 00:00:00 16 Saturday 6 June 1 0 No WK03 QTR04 2018 FY1819
229 100 2018-06-17 00:00:00 17 Sunday 6 June 1 0 No WK03 QTR04 2018 FY1819
230 100 2018-06-18 00:00:00 18 Monday 6 June 0 0 No WK03 QTR04 2018 FY1819
231 100 2018-06-19 00:00:00 19 Tuesday 6 June 0 0 No WK03 QTR04 2018 FY1819
232 100 2018-06-20 00:00:00 20 Wednesday 6 June 0 0 No WK03 QTR04 2018 FY1819
233 100 2018-06-21 00:00:00 21 Thursday 6 June 0 0 No WK03 QTR04 2018 FY1819
234 100 2018-06-22 00:00:00 22 Friday 6 June 0 0 No WK04 QTR04 2018 FY1819
235 100 2018-06-23 00:00:00 23 Saturday 6 June 1 0 No WK04 QTR04 2018 FY1819
236 100 2018-06-24 00:00:00 24 Sunday 6 June 1 0 No WK04 QTR04 2018 FY1819
237 100 2018-06-25 00:00:00 25 Monday 6 June 0 0 No WK04 QTR04 2018 FY1819
238 100 2018-06-26 00:00:00 26 Tuesday 6 June 0 0 No WK04 QTR04 2018 FY1819
239 100 2018-06-27 00:00:00 27 Wednesday 6 June 0 0 No WK04 QTR04 2018 FY1819
240 100 2018-06-28 00:00:00 28 Thursday 6 June 0 0 No WK04 QTR04 2018 FY1819
241 100 2018-06-29 00:00:00 29 Friday 6 June 0 0 No WK04 QTR04 2018 FY1819
242 100 2018-06-30 00:00:00 30 Saturday 6 June 1 0 No WK04 QTR04 2018 FY1819
243 100 2018-07-01 00:00:00 1 Sunday 7 July 1 0 No WK01 QTR04 2018 FY1819
244 100 2018-07-02 00:00:00 2 Monday 7 July 0 0 No WK01 QTR 2018 FY1819
245 100 2018-07-03 00:00:00 3 Tuesday 7 July 0 0 No WK01 QTR 2018 FY1819
246 100 2018-07-04 00:00:00 4 Wednesday 7 July 0 0 No WK01 QTR 2018 FY1819
247 100 2018-07-05 00:00:00 5 Thursday 7 July 0 0 No WK01 QTR 2018 FY1819
248 100 2018-07-06 00:00:00 6 Friday 7 July 0 0 No WK01 QTR 2018 FY1819
249 100 2018-07-07 00:00:00 7 Saturday 7 July 1 0 No WK01 QTR 2018 FY1819
250 100 2018-07-08 00:00:00 8 Sunday 7 July 1 0 No WK02 QTR 2018 FY1819
251 100 2018-07-09 00:00:00 9 Monday 7 July 0 0 No WK02 QTR 2018 FY1819
252 100 2018-07-10 00:00:00 10 Tuesday 7 July 0 0 No WK02 QTR 2018 FY1819
253 100 2018-07-11 00:00:00 11 Wednesday 7 July 0 0 No WK02 QTR 2018 FY1819
254 100 2018-07-12 00:00:00 12 Thursday 7 July 0 0 No WK02 QTR 2018 FY1819
255 100 2018-07-13 00:00:00 13 Friday 7 July 0 0 No WK02 QTR 2018 FY1819
256 100 2018-07-14 00:00:00 14 Saturday 7 July 1 0 No WK02 QTR 2018 FY1819
257 100 2018-07-15 00:00:00 15 Sunday 7 July 1 0 No WK03 QTR 2018 FY1819
258 100 2018-07-16 00:00:00 16 Monday 7 July 0 0 No WK03 QTR 2018 FY1819
259 100 2018-07-17 00:00:00 17 Tuesday 7 July 0 0 No WK03 QTR 2018 FY1819
260 100 2018-07-18 00:00:00 18 Wednesday 7 July 0 0 No WK03 QTR 2018 FY1819
261 100 2018-07-19 00:00:00 19 Thursday 7 July 0 0 No WK03 QTR 2018 FY1819
262 100 2018-07-20 00:00:00 20 Friday 7 July 0 0 No WK03 QTR 2018 FY1819
263 100 2018-07-21 00:00:00 21 Saturday 7 July 1 0 No WK03 QTR 2018 FY1819
264 100 2018-07-22 00:00:00 22 Sunday 7 July 1 0 No WK04 QTR 2018 FY1819
265 100 2018-07-23 00:00:00 23 Monday 7 July 0 0 No WK04 QTR 2018 FY1819
266 100 2018-07-24 00:00:00 24 Tuesday 7 July 0 0 No WK04 QTR 2018 FY1819
267 100 2018-07-25 00:00:00 25 Wednesday 7 July 0 0 No WK04 QTR 2018 FY1819
268 100 2018-07-26 00:00:00 26 Thursday 7 July 0 0 No WK04 QTR 2018 FY1819
269 100 2018-07-27 00:00:00 27 Friday 7 July 0 0 No WK04 QTR 2018 FY1819
270 100 2018-07-28 00:00:00 28 Saturday 7 July 1 0 No WK04 QTR 2018 FY1819
271 100 2018-07-29 00:00:00 29 Sunday 7 July 1 0 No WK04 QTR 2018 FY1819
272 100 2018-07-30 00:00:00 30 Monday 7 July 0 0 No WK04 QTR 2018 FY1819
273 100 2018-07-31 00:00:00 31 Tuesday 7 July 0 0 No WK QTR 2018 FY1819
274 100 2018-08-01 00:00:00 1 Wednesday 8 August 0 0 No WK01 QTR 2018 FY1819
275 100 2018-08-02 00:00:00 2 Thursday 8 August 0 0 No WK01 QTR 2018 FY1819
276 100 2018-08-03 00:00:00 3 Friday 8 August 0 0 No WK01 QTR 2018 FY1819
277 100 2018-08-04 00:00:00 4 Saturday 8 August 1 0 No WK01 QTR 2018 FY1819
278 100 2018-08-05 00:00:00 5 Sunday 8 August 1 0 No WK01 QTR 2018 FY1819
279 100 2018-08-06 00:00:00 6 Monday 8 August 0 0 No WK01 QTR 2018 FY1819
280 100 2018-08-07 00:00:00 7 Tuesday 8 August 0 0 No WK01 QTR 2018 FY1819
281 100 2018-08-08 00:00:00 8 Wednesday 8 August 0 0 No WK02 QTR 2018 FY1819
282 100 2018-08-09 00:00:00 9 Thursday 8 August 0 0 No WK02 QTR 2018 FY1819
283 100 2018-08-10 00:00:00 10 Friday 8 August 0 0 No WK02 QTR 2018 FY1819
284 100 2018-08-11 00:00:00 11 Saturday 8 August 1 0 No WK02 QTR 2018 FY1819
285 100 2018-08-12 00:00:00 12 Sunday 8 August 1 0 No WK02 QTR 2018 FY1819
286 100 2018-08-13 00:00:00 13 Monday 8 August 0 0 No WK02 QTR 2018 FY1819
287 100 2018-08-14 00:00:00 14 Tuesday 8 August 0 0 No WK02 QTR 2018 FY1819
288 100 2018-08-15 00:00:00 15 Wednesday 8 August 0 0 No WK03 QTR 2018 FY1819
289 100 2018-08-16 00:00:00 16 Thursday 8 August 0 0 No WK03 QTR 2018 FY1819
290 100 2018-08-17 00:00:00 17 Friday 8 August 0 0 No WK03 QTR 2018 FY1819
291 100 2018-08-18 00:00:00 18 Saturday 8 August 1 0 No WK03 QTR 2018 FY1819
292 100 2018-08-19 00:00:00 19 Sunday 8 August 1 0 No WK03 QTR 2018 FY1819
293 100 2018-08-20 00:00:00 20 Monday 8 August 0 0 No WK03 QTR 2018 FY1819
294 100 2018-08-21 00:00:00 21 Tuesday 8 August 0 0 No WK03 QTR 2018 FY1819
295 100 2018-08-22 00:00:00 22 Wednesday 8 August 0 0 No WK04 QTR 2018 FY1819
296 100 2018-08-23 00:00:00 23 Thursday 8 August 0 0 No WK04 QTR 2018 FY1819
297 100 2018-08-24 00:00:00 24 Friday 8 August 0 0 No WK04 QTR 2018 FY1819
298 100 2018-08-25 00:00:00 25 Saturday 8 August 1 0 No WK04 QTR 2018 FY1819
299 100 2018-08-26 00:00:00 26 Sunday 8 August 1 0 No WK04 QTR 2018 FY1819
300 100 2018-08-27 00:00:00 27 Monday 8 August 0 0 No WK04 QTR 2018 FY1819
301 100 2018-08-28 00:00:00 28 Tuesday 8 August 0 0 No WK04 QTR 2018 FY1819
302 100 2018-08-29 00:00:00 29 Wednesday 8 August 0 0 No WK04 QTR 2018 FY1819
303 100 2018-08-30 00:00:00 30 Thursday 8 August 0 0 No WK04 QTR 2018 FY1819
304 100 2018-08-31 00:00:00 31 Friday 8 August 0 0 No WK QTR 2018 FY1819
305 100 2018-09-01 00:00:00 1 Saturday 9 September 1 0 No WK01 QTR 2018 FY1819
306 100 2018-09-02 00:00:00 2 Sunday 9 September 1 0 No WK01 QTR 2018 FY1819
307 100 2018-09-03 00:00:00 3 Monday 9 September 0 0 No WK01 QTR 2018 FY1819
308 100 2018-09-04 00:00:00 4 Tuesday 9 September 0 0 No WK01 QTR 2018 FY1819
309 100 2018-09-05 00:00:00 5 Wednesday 9 September 0 0 No WK01 QTR 2018 FY1819
310 100 2018-09-06 00:00:00 6 Thursday 9 September 0 0 No WK01 QTR 2018 FY1819
311 100 2018-09-07 00:00:00 7 Friday 9 September 0 0 No WK01 QTR 2018 FY1819
312 100 2018-09-08 00:00:00 8 Saturday 9 September 1 0 No WK02 QTR 2018 FY1819
313 100 2018-09-09 00:00:00 9 Sunday 9 September 1 0 No WK02 QTR 2018 FY1819
314 100 2018-09-10 00:00:00 10 Monday 9 September 0 0 No WK02 QTR 2018 FY1819
315 100 2018-09-11 00:00:00 11 Tuesday 9 September 0 0 No WK02 QTR 2018 FY1819
316 100 2018-09-12 00:00:00 12 Wednesday 9 September 0 0 No WK02 QTR 2018 FY1819
317 100 2018-09-13 00:00:00 13 Thursday 9 September 0 0 No WK02 QTR 2018 FY1819
318 100 2018-09-14 00:00:00 14 Friday 9 September 0 0 No WK02 QTR 2018 FY1819
319 100 2018-09-15 00:00:00 15 Saturday 9 September 1 0 No WK03 QTR 2018 FY1819
320 100 2018-09-16 00:00:00 16 Sunday 9 September 1 0 No WK03 QTR 2018 FY1819
321 100 2018-09-17 00:00:00 17 Monday 9 September 0 0 No WK03 QTR 2018 FY1819
322 100 2018-09-18 00:00:00 18 Tuesday 9 September 0 0 No WK03 QTR 2018 FY1819
323 100 2018-09-19 00:00:00 19 Wednesday 9 September 0 0 No WK03 QTR 2018 FY1819
324 100 2018-09-20 00:00:00 20 Thursday 9 September 0 0 No WK03 QTR 2018 FY1819
325 100 2018-09-21 00:00:00 21 Friday 9 September 0 0 No WK03 QTR 2018 FY1819
326 100 2018-09-22 00:00:00 22 Saturday 9 September 1 0 No WK04 QTR 2018 FY1819
327 100 2018-09-23 00:00:00 23 Sunday 9 September 1 0 No WK04 QTR 2018 FY1819
328 100 2018-09-24 00:00:00 24 Monday 9 September 0 0 No WK04 QTR 2018 FY1819
329 100 2018-09-25 00:00:00 25 Tuesday 9 September 0 0 No WK04 QTR 2018 FY1819
330 100 2018-09-26 00:00:00 26 Wednesday 9 September 0 0 No WK04 QTR 2018 FY1819
331 100 2018-09-27 00:00:00 27 Thursday 9 September 0 0 No WK04 QTR 2018 FY1819
332 100 2018-09-28 00:00:00 28 Friday 9 September 0 0 No WK04 QTR 2018 FY1819
333 100 2018-09-29 00:00:00 29 Saturday 9 September 1 0 No WK04 QTR 2018 FY1819
334 100 2018-09-30 00:00:00 30 Sunday 9 September 1 0 No WK04 QTR 2018 FY1819
335 100 2018-10-01 00:00:00 1 Monday 10 October 0 0 No WK01 QTR 2018 FY1819
336 100 2018-10-02 00:00:00 2 Tuesday 10 October 0 0 No WK01 QTR 2018 FY1819
337 100 2018-10-03 00:00:00 3 Wednesday 10 October 0 0 No WK01 QTR 2018 FY1819
338 100 2018-10-04 00:00:00 4 Thursday 10 October 0 0 No WK01 QTR 2018 FY1819
339 100 2018-10-05 00:00:00 5 Friday 10 October 0 0 No WK01 QTR 2018 FY1819
340 100 2018-10-06 00:00:00 6 Saturday 10 October 1 0 No WK01 QTR 2018 FY1819
341 100 2018-10-07 00:00:00 7 Sunday 10 October 1 0 No WK01 QTR 2018 FY1819
342 100 2018-10-08 00:00:00 8 Monday 10 October 0 0 No WK02 QTR 2018 FY1819
343 100 2018-10-09 00:00:00 9 Tuesday 10 October 0 0 No WK02 QTR 2018 FY1819
344 100 2018-10-10 00:00:00 10 Wednesday 10 October 0 0 No WK02 QTR 2018 FY1819
345 100 2018-10-11 00:00:00 11 Thursday 10 October 0 0 No WK02 QTR 2018 FY1819
346 100 2018-10-12 00:00:00 12 Friday 10 October 0 0 No WK02 QTR 2018 FY1819
347 100 2018-10-13 00:00:00 13 Saturday 10 October 1 0 No WK02 QTR 2018 FY1819
348 100 2018-10-14 00:00:00 14 Sunday 10 October 1 0 No WK02 QTR 2018 FY1819
349 100 2018-10-15 00:00:00 15 Monday 10 October 0 0 No WK03 QTR 2018 FY1819
350 100 2018-10-16 00:00:00 16 Tuesday 10 October 0 0 No WK03 QTR 2018 FY1819
351 100 2018-10-17 00:00:00 17 Wednesday 10 October 0 0 No WK03 QTR 2018 FY1819
352 100 2018-10-18 00:00:00 18 Thursday 10 October 0 0 No WK03 QTR 2018 FY1819
353 100 2018-10-19 00:00:00 19 Friday 10 October 0 0 No WK03 QTR 2018 FY1819
354 100 2018-10-20 00:00:00 20 Saturday 10 October 1 0 No WK03 QTR 2018 FY1819
355 100 2018-10-21 00:00:00 21 Sunday 10 October 1 0 No WK03 QTR 2018 FY1819
356 100 2018-10-22 00:00:00 22 Monday 10 October 0 0 No WK04 QTR 2018 FY1819
357 100 2018-10-23 00:00:00 23 Tuesday 10 October 0 0 No WK04 QTR 2018 FY1819
358 100 2018-10-24 00:00:00 24 Wednesday 10 October 0 0 No WK04 QTR 2018 FY1819
359 100 2018-10-25 00:00:00 25 Thursday 10 October 0 0 No WK04 QTR 2018 FY1819
360 100 2018-10-26 00:00:00 26 Friday 10 October 0 0 No WK04 QTR 2018 FY1819
361 100 2018-10-27 00:00:00 27 Saturday 10 October 1 0 No WK04 QTR 2018 FY1819
362 100 2018-10-28 00:00:00 28 Sunday 10 October 1 0 No WK04 QTR 2018 FY1819
363 100 2018-10-29 00:00:00 29 Monday 10 October 0 0 No WK04 QTR 2018 FY1819
364 100 2018-10-30 00:00:00 30 Tuesday 10 October 0 0 No WK04 QTR 2018 FY1819
365 100 2018-10-31 00:00:00 31 Wednesday 10 October 0 0 No WK QTR 2018 FY1819
366 100 2018-11-01 00:00:00 1 Thursday 11 November 0 0 No WK01 QTR 2018 FY1819
367 100 2018-11-02 00:00:00 2 Friday 11 November 0 0 No WK01 QTR 2018 FY1819
368 100 2018-11-03 00:00:00 3 Saturday 11 November 1 0 No WK01 QTR 2018 FY1819
369 100 2018-11-04 00:00:00 4 Sunday 11 November 1 0 No WK01 QTR 2018 FY1819
370 100 2018-11-05 00:00:00 5 Monday 11 November 0 0 No WK01 QTR 2018 FY1819
371 100 2018-11-06 00:00:00 6 Tuesday 11 November 0 0 No WK01 QTR 2018 FY1819
372 100 2018-11-07 00:00:00 7 Wednesday 11 November 0 0 No WK01 QTR 2018 FY1819
373 100 2018-11-08 00:00:00 8 Thursday 11 November 0 0 No WK02 QTR 2018 FY1819
374 100 2018-11-09 00:00:00 9 Friday 11 November 0 0 No WK02 QTR 2018 FY1819
375 100 2018-11-10 00:00:00 10 Saturday 11 November 1 0 No WK02 QTR 2018 FY1819
376 100 2018-11-11 00:00:00 11 Sunday 11 November 1 0 No WK02 QTR 2018 FY1819
377 100 2018-11-12 00:00:00 12 Monday 11 November 0 0 No WK02 QTR 2018 FY1819
378 100 2018-11-13 00:00:00 13 Tuesday 11 November 0 0 No WK02 QTR 2018 FY1819
379 100 2018-11-14 00:00:00 14 Wednesday 11 November 0 0 No WK02 QTR 2018 FY1819
380 100 2018-11-15 00:00:00 15 Thursday 11 November 0 0 No WK03 QTR 2018 FY1819
381 100 2018-11-16 00:00:00 16 Friday 11 November 0 0 No WK03 QTR 2018 FY1819
382 100 2018-11-17 00:00:00 17 Saturday 11 November 1 0 No WK03 QTR 2018 FY1819
383 100 2018-11-18 00:00:00 18 Sunday 11 November 1 0 No WK03 QTR 2018 FY1819
384 100 2018-11-19 00:00:00 19 Monday 11 November 0 0 No WK03 QTR 2018 FY1819
385 100 2018-11-20 00:00:00 20 Tuesday 11 November 0 0 No WK03 QTR 2018 FY1819
386 100 2018-11-21 00:00:00 21 Wednesday 11 November 0 0 No WK03 QTR 2018 FY1819
387 100 2018-11-22 00:00:00 22 Thursday 11 November 0 0 No WK04 QTR 2018 FY1819
388 100 2018-11-23 00:00:00 23 Friday 11 November 0 0 No WK04 QTR 2018 FY1819
389 100 2018-11-24 00:00:00 24 Saturday 11 November 1 0 No WK04 QTR 2018 FY1819
390 100 2018-11-25 00:00:00 25 Sunday 11 November 1 0 No WK04 QTR 2018 FY1819
391 100 2018-11-26 00:00:00 26 Monday 11 November 0 0 No WK04 QTR 2018 FY1819
392 100 2018-11-27 00:00:00 27 Tuesday 11 November 0 0 No WK04 QTR 2018 FY1819
393 100 2018-11-28 00:00:00 28 Wednesday 11 November 0 0 No WK04 QTR 2018 FY1819
394 100 2018-11-29 00:00:00 29 Thursday 11 November 0 0 No WK04 QTR 2018 FY1819
395 100 2018-11-30 00:00:00 30 Friday 11 November 0 0 No WK04 QTR 2018 FY1819
396 100 2018-12-01 00:00:00 1 Saturday 12 December 1 0 No WK01 QTR 2018 FY1819
397 100 2018-12-02 00:00:00 2 Sunday 12 December 1 0 No WK01 QTR 2018 FY1819
398 100 2018-12-03 00:00:00 3 Monday 12 December 0 0 No WK01 QTR 2018 FY1819
399 100 2018-12-04 00:00:00 4 Tuesday 12 December 0 0 No WK01 QTR 2018 FY1819
400 100 2018-12-05 00:00:00 5 Wednesday 12 December 0 0 No WK01 QTR 2018 FY1819
401 100 2018-12-06 00:00:00 6 Thursday 12 December 0 0 No WK01 QTR 2018 FY1819
402 100 2018-12-07 00:00:00 7 Friday 12 December 0 0 No WK01 QTR 2018 FY1819
403 100 2018-12-08 00:00:00 8 Saturday 12 December 1 0 No WK02 QTR 2018 FY1819
404 100 2018-12-09 00:00:00 9 Sunday 12 December 1 0 No WK02 QTR 2018 FY1819
405 100 2018-12-10 00:00:00 10 Monday 12 December 0 0 No WK02 QTR 2018 FY1819
406 100 2018-12-11 00:00:00 11 Tuesday 12 December 0 0 No WK02 QTR 2018 FY1819
407 100 2018-12-12 00:00:00 12 Wednesday 12 December 0 0 No WK02 QTR 2018 FY1819
408 100 2018-12-13 00:00:00 13 Thursday 12 December 0 0 No WK02 QTR 2018 FY1819
409 100 2018-12-14 00:00:00 14 Friday 12 December 0 0 No WK02 QTR 2018 FY1819
410 100 2018-12-15 00:00:00 15 Saturday 12 December 1 0 No WK03 QTR 2018 FY1819
411 100 2018-12-16 00:00:00 16 Sunday 12 December 1 0 No WK03 QTR 2018 FY1819
412 100 2018-12-17 00:00:00 17 Monday 12 December 0 0 No WK03 QTR 2018 FY1819
413 100 2018-12-18 00:00:00 18 Tuesday 12 December 0 0 No WK03 QTR 2018 FY1819
414 100 2018-12-19 00:00:00 19 Wednesday 12 December 0 0 No WK03 QTR 2018 FY1819
415 100 2018-12-20 00:00:00 20 Thursday 12 December 0 0 No WK03 QTR 2018 FY1819
416 100 2018-12-21 00:00:00 21 Friday 12 December 0 0 No WK03 QTR 2018 FY1819
417 100 2018-12-22 00:00:00 22 Saturday 12 December 1 0 No WK04 QTR 2018 FY1819
418 100 2018-12-23 00:00:00 23 Sunday 12 December 1 0 No WK04 QTR 2018 FY1819
419 100 2018-12-24 00:00:00 24 Monday 12 December 0 0 No WK04 QTR 2018 FY1819
420 100 2018-12-25 00:00:00 25 Tuesday 12 December 0 0 No WK04 QTR 2018 FY1819
421 100 2018-12-26 00:00:00 26 Wednesday 12 December 0 0 No WK04 QTR 2018 FY1819
422 100 2018-12-27 00:00:00 27 Thursday 12 December 0 0 No WK04 QTR 2018 FY1819
423 100 2018-12-28 00:00:00 28 Friday 12 December 0 0 No WK04 QTR 2018 FY1819
424 100 2018-12-29 00:00:00 29 Saturday 12 December 1 0 No WK04 QTR 2018 FY1819
425 100 2018-12-30 00:00:00 30 Sunday 12 December 1 0 No WK04 QTR 2018 FY1819
426 100 2018-12-31 00:00:00 31 Monday 12 December 0 0 No WK QTR 2018 FY1819
427 100 2019-01-01 00:00:00 1 Tuesday 1 January 0 0 No WK01 QTR 2019 FY1920
428 100 2019-01-02 00:00:00 2 Wednesday 1 January 0 0 No WK01 QTR 2019 FY1920
429 100 2019-01-03 00:00:00 3 Thursday 1 January 0 0 No WK01 QTR 2019 FY1920
430 100 2019-01-04 00:00:00 4 Friday 1 January 0 0 No WK01 QTR 2019 FY1920
431 100 2019-01-05 00:00:00 5 Saturday 1 January 1 0 No WK01 QTR 2019 FY1920
432 100 2019-01-06 00:00:00 6 Sunday 1 January 1 0 No WK01 QTR 2019 FY1920
433 100 2019-01-07 00:00:00 7 Monday 1 January 0 0 No WK01 QTR 2019 FY1920
434 100 2019-01-08 00:00:00 8 Tuesday 1 January 0 0 No WK02 QTR 2019 FY1920
435 100 2019-01-09 00:00:00 9 Wednesday 1 January 0 0 No WK02 QTR 2019 FY1920
436 100 2019-01-10 00:00:00 10 Thursday 1 January 0 0 No WK02 QTR 2019 FY1920
437 100 2019-01-11 00:00:00 11 Friday 1 January 0 0 No WK02 QTR 2019 FY1920
438 100 2019-01-12 00:00:00 12 Saturday 1 January 1 0 No WK02 QTR 2019 FY1920
439 100 2019-01-13 00:00:00 13 Sunday 1 January 1 0 No WK02 QTR 2019 FY1920
440 100 2019-01-14 00:00:00 14 Monday 1 January 0 0 No WK02 QTR 2019 FY1920
441 100 2019-01-15 00:00:00 15 Tuesday 1 January 0 0 No WK03 QTR 2019 FY1920
442 100 2019-01-16 00:00:00 16 Wednesday 1 January 0 0 No WK03 QTR 2019 FY1920
443 100 2019-01-17 00:00:00 17 Thursday 1 January 0 0 No WK03 QTR 2019 FY1920
444 100 2019-01-18 00:00:00 18 Friday 1 January 0 0 No WK03 QTR 2019 FY1920
445 100 2019-01-19 00:00:00 19 Saturday 1 January 1 0 No WK03 QTR 2019 FY1920
446 100 2019-01-20 00:00:00 20 Sunday 1 January 1 0 No WK03 QTR 2019 FY1920
447 100 2019-01-21 00:00:00 21 Monday 1 January 0 0 No WK03 QTR 2019 FY1920
448 100 2019-01-22 00:00:00 22 Tuesday 1 January 0 0 No WK04 QTR 2019 FY1920
449 100 2019-01-23 00:00:00 23 Wednesday 1 January 0 0 No WK04 QTR 2019 FY1920
450 100 2019-01-24 00:00:00 24 Thursday 1 January 0 0 No WK04 QTR 2019 FY1920
451 100 2019-01-25 00:00:00 25 Friday 1 January 0 0 No WK04 QTR 2019 FY1920
452 100 2019-01-26 00:00:00 26 Saturday 1 January 1 0 No WK04 QTR 2019 FY1920
453 100 2019-01-27 00:00:00 27 Sunday 1 January 1 0 No WK04 QTR 2019 FY1920
454 100 2019-01-28 00:00:00 28 Monday 1 January 0 0 No WK04 QTR 2019 FY1920
455 100 2019-01-29 00:00:00 29 Tuesday 1 January 0 0 No WK04 QTR 2019 FY1920
456 100 2019-01-30 00:00:00 30 Wednesday 1 January 0 0 No WK04 QTR 2019 FY1920
457 100 2019-01-31 00:00:00 31 Thursday 1 January 0 0 No WK QTR 2019 FY1920
458 100 2019-02-01 00:00:00 1 Friday 2 February 0 0 No WK01 QTR 2019 FY1920
459 100 2019-02-02 00:00:00 2 Saturday 2 February 1 0 No WK01 QTR 2019 FY1920
460 100 2019-02-03 00:00:00 3 Sunday 2 February 1 0 No WK01 QTR 2019 FY1920
461 100 2019-02-04 00:00:00 4 Monday 2 February 0 0 No WK01 QTR 2019 FY1920
462 100 2019-02-05 00:00:00 5 Tuesday 2 February 0 0 No WK01 QTR 2019 FY1920
463 100 2019-02-06 00:00:00 6 Wednesday 2 February 0 0 No WK01 QTR 2019 FY1920
464 100 2019-02-07 00:00:00 7 Thursday 2 February 0 0 No WK01 QTR 2019 FY1920
465 100 2019-02-08 00:00:00 8 Friday 2 February 0 0 No WK02 QTR 2019 FY1920
466 100 2019-02-09 00:00:00 9 Saturday 2 February 1 0 No WK02 QTR 2019 FY1920
467 100 2019-02-10 00:00:00 10 Sunday 2 February 1 0 No WK02 QTR 2019 FY1920
468 100 2019-02-11 00:00:00 11 Monday 2 February 0 0 No WK02 QTR 2019 FY1920
469 100 2019-02-12 00:00:00 12 Tuesday 2 February 0 0 No WK02 QTR 2019 FY1920
470 100 2019-02-13 00:00:00 13 Wednesday 2 February 0 0 No WK02 QTR 2019 FY1920
471 100 2019-02-14 00:00:00 14 Thursday 2 February 0 0 No WK02 QTR 2019 FY1920
472 100 2019-02-15 00:00:00 15 Friday 2 February 0 0 No WK03 QTR 2019 FY1920
473 100 2019-02-16 00:00:00 16 Saturday 2 February 1 0 No WK03 QTR 2019 FY1920
474 100 2019-02-17 00:00:00 17 Sunday 2 February 1 0 No WK03 QTR 2019 FY1920
475 100 2019-02-18 00:00:00 18 Monday 2 February 0 0 No WK03 QTR 2019 FY1920
476 100 2019-02-19 00:00:00 19 Tuesday 2 February 0 0 No WK03 QTR 2019 FY1920
477 100 2019-02-20 00:00:00 20 Wednesday 2 February 0 0 No WK03 QTR 2019 FY1920
478 100 2019-02-21 00:00:00 21 Thursday 2 February 0 0 No WK03 QTR 2019 FY1920
479 100 2019-02-22 00:00:00 22 Friday 2 February 0 0 No WK04 QTR 2019 FY1920
480 100 2019-02-23 00:00:00 23 Saturday 2 February 1 0 No WK04 QTR 2019 FY1920
481 100 2019-02-24 00:00:00 24 Sunday 2 February 1 0 No WK04 QTR 2019 FY1920
482 100 2019-02-25 00:00:00 25 Monday 2 February 0 0 No WK04 QTR 2019 FY1920
483 100 2019-02-26 00:00:00 26 Tuesday 2 February 0 0 No WK04 QTR 2019 FY1920
484 100 2019-02-27 00:00:00 27 Wednesday 2 February 0 0 No WK04 QTR 2019 FY1920
485 100 2019-02-28 00:00:00 28 Thursday 2 February 0 0 No WK04 QTR 2019 FY1920
486 100 2019-03-01 00:00:00 1 Friday 3 March 0 0 No WK01 QTR 2019 FY1920
487 100 2019-03-02 00:00:00 2 Saturday 3 March 1 0 No WK01 QTR 2019 FY1920
488 100 2019-03-03 00:00:00 3 Sunday 3 March 1 0 No WK01 QTR 2019 FY1920
489 100 2019-03-04 00:00:00 4 Monday 3 March 0 0 No WK01 QTR 2019 FY1920
490 100 2019-03-05 00:00:00 5 Tuesday 3 March 0 0 No WK01 QTR 2019 FY1920
491 100 2019-03-06 00:00:00 6 Wednesday 3 March 0 0 No WK01 QTR 2019 FY1920
492 100 2019-03-07 00:00:00 7 Thursday 3 March 0 0 No WK01 QTR 2019 FY1920
493 100 2019-03-08 00:00:00 8 Friday 3 March 0 0 No WK02 QTR 2019 FY1920
494 100 2019-03-09 00:00:00 9 Saturday 3 March 1 0 No WK02 QTR 2019 FY1920
495 100 2019-03-10 00:00:00 10 Sunday 3 March 1 0 No WK02 QTR 2019 FY1920
496 100 2019-03-11 00:00:00 11 Monday 3 March 0 0 No WK02 QTR 2019 FY1920
497 100 2019-03-12 00:00:00 12 Tuesday 3 March 0 0 No WK02 QTR 2019 FY1920
498 100 2019-03-13 00:00:00 13 Wednesday 3 March 0 0 No WK02 QTR 2019 FY1920
499 100 2019-03-14 00:00:00 14 Thursday 3 March 0 0 No WK02 QTR 2019 FY1920
500 100 2019-03-15 00:00:00 15 Friday 3 March 0 0 No WK03 QTR 2019 FY1920
501 100 2019-03-16 00:00:00 16 Saturday 3 March 1 0 No WK03 QTR 2019 FY1920
502 100 2019-03-17 00:00:00 17 Sunday 3 March 1 0 No WK03 QTR 2019 FY1920
503 100 2019-03-18 00:00:00 18 Monday 3 March 0 0 No WK03 QTR 2019 FY1920
504 100 2019-03-19 00:00:00 19 Tuesday 3 March 0 0 No WK03 QTR 2019 FY1920
505 100 2019-03-20 00:00:00 20 Wednesday 3 March 0 0 No WK03 QTR 2019 FY1920
506 100 2019-03-21 00:00:00 21 Thursday 3 March 0 0 No WK03 QTR 2019 FY1920
507 100 2019-03-22 00:00:00 22 Friday 3 March 0 0 No WK04 QTR 2019 FY1920
508 100 2019-03-23 00:00:00 23 Saturday 3 March 1 0 No WK04 QTR 2019 FY1920
509 100 2019-03-24 00:00:00 24 Sunday 3 March 1 0 No WK04 QTR 2019 FY1920
510 100 2019-03-25 00:00:00 25 Monday 3 March 0 0 No WK04 QTR 2019 FY1920
511 100 2019-03-26 00:00:00 26 Tuesday 3 March 0 0 No WK04 QTR 2019 FY1920
512 100 2019-03-27 00:00:00 27 Wednesday 3 March 0 0 No WK04 QTR 2019 FY1920
513 100 2019-03-28 00:00:00 28 Thursday 3 March 0 0 No WK04 QTR 2019 FY1920
514 100 2019-03-29 00:00:00 29 Friday 3 March 0 0 No WK04 QTR 2019 FY1920
515 100 2019-03-30 00:00:00 30 Saturday 3 March 1 0 No WK04 QTR 2019 FY1920
516 100 2019-03-31 00:00:00 31 Sunday 3 March 1 0 No WK QTR 2019 FY1920
517 100 2019-04-01 00:00:00 1 Monday 4 April 0 0 No WK01 QTR 2019 FY1920
518 100 2019-04-02 00:00:00 2 Tuesday 4 April 0 0 No WK01 QTR 2019 FY1920
519 100 2019-04-03 00:00:00 3 Wednesday 4 April 0 0 No WK01 QTR 2019 FY1920
520 100 2019-04-04 00:00:00 4 Thursday 4 April 0 0 No WK01 QTR 2019 FY1920
521 100 2019-04-05 00:00:00 5 Friday 4 April 0 0 No WK01 QTR 2019 FY1920
522 100 2019-04-06 00:00:00 6 Saturday 4 April 1 0 No WK01 QTR 2019 FY1920
523 100 2019-04-07 00:00:00 7 Sunday 4 April 1 0 No WK01 QTR 2019 FY1920
524 100 2019-04-08 00:00:00 8 Monday 4 April 0 0 No WK02 QTR 2019 FY1920
525 100 2019-04-09 00:00:00 9 Tuesday 4 April 0 0 No WK02 QTR 2019 FY1920
526 100 2019-04-10 00:00:00 10 Wednesday 4 April 0 0 No WK02 QTR 2019 FY1920
527 100 2019-04-11 00:00:00 11 Thursday 4 April 0 0 No WK02 QTR 2019 FY1920
528 100 2019-04-12 00:00:00 12 Friday 4 April 0 0 No WK02 QTR 2019 FY1920
529 100 2019-04-13 00:00:00 13 Saturday 4 April 1 0 No WK02 QTR 2019 FY1920
530 100 2019-04-14 00:00:00 14 Sunday 4 April 1 0 No WK02 QTR 2019 FY1920
531 100 2019-04-15 00:00:00 15 Monday 4 April 0 0 No WK03 QTR 2019 FY1920
532 100 2019-04-16 00:00:00 16 Tuesday 4 April 0 0 No WK03 QTR 2019 FY1920
533 100 2019-04-17 00:00:00 17 Wednesday 4 April 0 0 No WK03 QTR 2019 FY1920
534 100 2019-04-18 00:00:00 18 Thursday 4 April 0 0 No WK03 QTR 2019 FY1920
535 100 2019-04-19 00:00:00 19 Friday 4 April 0 0 No WK03 QTR 2019 FY1920
536 100 2019-04-20 00:00:00 20 Saturday 4 April 1 0 No WK03 QTR 2019 FY1920
537 100 2019-04-21 00:00:00 21 Sunday 4 April 1 0 No WK03 QTR 2019 FY1920
538 100 2019-04-22 00:00:00 22 Monday 4 April 0 0 No WK04 QTR 2019 FY1920
539 100 2019-04-23 00:00:00 23 Tuesday 4 April 0 0 No WK04 QTR 2019 FY1920
540 100 2019-04-24 00:00:00 24 Wednesday 4 April 0 0 No WK04 QTR 2019 FY1920
541 100 2019-04-25 00:00:00 25 Thursday 4 April 0 0 No WK04 QTR 2019 FY1920
542 100 2019-04-26 00:00:00 26 Friday 4 April 0 0 No WK04 QTR 2019 FY1920
543 100 2019-04-27 00:00:00 27 Saturday 4 April 1 0 No WK04 QTR 2019 FY1920
544 100 2019-04-28 00:00:00 28 Sunday 4 April 1 0 No WK04 QTR 2019 FY1920
545 100 2019-04-29 00:00:00 29 Monday 4 April 0 0 No WK04 QTR 2019 FY1920
546 100 2019-04-30 00:00:00 30 Tuesday 4 April 0 0 No WK04 QTR 2019 FY1920
547 100 2019-05-01 00:00:00 1 Wednesday 5 May 0 0 No WK01 QTR 2019 FY1920
548 100 2019-05-02 00:00:00 2 Thursday 5 May 0 0 No WK01 QTR 2019 FY1920
549 100 2019-05-03 00:00:00 3 Friday 5 May 0 0 No WK01 QTR 2019 FY1920
550 100 2019-05-04 00:00:00 4 Saturday 5 May 1 0 No WK01 QTR 2019 FY1920
551 100 2019-05-05 00:00:00 5 Sunday 5 May 1 0 No WK01 QTR 2019 FY1920
552 100 2019-05-06 00:00:00 6 Monday 5 May 0 0 No WK01 QTR 2019 FY1920
553 100 2019-05-07 00:00:00 7 Tuesday 5 May 0 0 No WK01 QTR 2019 FY1920
554 100 2019-05-08 00:00:00 8 Wednesday 5 May 0 0 No WK02 QTR 2019 FY1920
555 100 2019-05-09 00:00:00 9 Thursday 5 May 0 0 No WK02 QTR 2019 FY1920
556 100 2019-05-10 00:00:00 10 Friday 5 May 0 0 No WK02 QTR 2019 FY1920
557 100 2019-05-11 00:00:00 11 Saturday 5 May 1 0 No WK02 QTR 2019 FY1920
558 100 2019-05-12 00:00:00 12 Sunday 5 May 1 0 No WK02 QTR 2019 FY1920
559 100 2019-05-13 00:00:00 13 Monday 5 May 0 0 No WK02 QTR 2019 FY1920
560 100 2019-05-14 00:00:00 14 Tuesday 5 May 0 0 No WK02 QTR 2019 FY1920
561 100 2019-05-15 00:00:00 15 Wednesday 5 May 0 0 No WK03 QTR 2019 FY1920
562 100 2019-05-16 00:00:00 16 Thursday 5 May 0 0 No WK03 QTR 2019 FY1920
563 100 2019-05-17 00:00:00 17 Friday 5 May 0 0 No WK03 QTR 2019 FY1920
564 100 2019-05-18 00:00:00 18 Saturday 5 May 1 0 No WK03 QTR 2019 FY1920
565 100 2019-05-19 00:00:00 19 Sunday 5 May 1 0 No WK03 QTR 2019 FY1920
566 100 2019-05-20 00:00:00 20 Monday 5 May 0 0 No WK03 QTR 2019 FY1920
567 100 2019-05-21 00:00:00 21 Tuesday 5 May 0 0 No WK03 QTR 2019 FY1920
568 100 2019-05-22 00:00:00 22 Wednesday 5 May 0 0 No WK04 QTR 2019 FY1920
569 100 2019-05-23 00:00:00 23 Thursday 5 May 0 0 No WK04 QTR 2019 FY1920
570 100 2019-05-24 00:00:00 24 Friday 5 May 0 0 No WK04 QTR 2019 FY1920
571 100 2019-05-25 00:00:00 25 Saturday 5 May 1 0 No WK04 QTR 2019 FY1920
572 100 2019-05-26 00:00:00 26 Sunday 5 May 1 0 No WK04 QTR 2019 FY1920
573 100 2019-05-27 00:00:00 27 Monday 5 May 0 0 No WK04 QTR 2019 FY1920
574 100 2019-05-28 00:00:00 28 Tuesday 5 May 0 0 No WK04 QTR 2019 FY1920
575 100 2019-05-29 00:00:00 29 Wednesday 5 May 0 0 No WK04 QTR 2019 FY1920
576 100 2019-05-30 00:00:00 30 Thursday 5 May 0 0 No WK04 QTR 2019 FY1920
577 100 2019-05-31 00:00:00 31 Friday 5 May 0 0 No WK QTR 2019 FY1920
578 100 2019-06-01 00:00:00 1 Saturday 6 June 1 0 No WK01 QTR 2019 FY1920
579 100 2019-06-02 00:00:00 2 Sunday 6 June 1 0 No WK01 QTR 2019 FY1920
580 100 2019-06-03 00:00:00 3 Monday 6 June 0 0 No WK01 QTR 2019 FY1920
581 100 2019-06-04 00:00:00 4 Tuesday 6 June 0 0 No WK01 QTR 2019 FY1920
582 100 2019-06-05 00:00:00 5 Wednesday 6 June 0 0 No WK01 QTR 2019 FY1920
583 100 2019-06-06 00:00:00 6 Thursday 6 June 0 0 No WK01 QTR 2019 FY1920
584 100 2019-06-07 00:00:00 7 Friday 6 June 0 0 No WK01 QTR 2019 FY1920
585 100 2019-06-08 00:00:00 8 Saturday 6 June 1 0 No WK02 QTR 2019 FY1920
586 100 2019-06-09 00:00:00 9 Sunday 6 June 1 0 No WK02 QTR 2019 FY1920
587 100 2019-06-10 00:00:00 10 Monday 6 June 0 0 No WK02 QTR 2019 FY1920
588 100 2019-06-11 00:00:00 11 Tuesday 6 June 0 0 No WK02 QTR 2019 FY1920
589 100 2019-06-12 00:00:00 12 Wednesday 6 June 0 0 No WK02 QTR 2019 FY1920
590 100 2019-06-13 00:00:00 13 Thursday 6 June 0 0 No WK02 QTR 2019 FY1920
591 100 2019-06-14 00:00:00 14 Friday 6 June 0 0 No WK02 QTR 2019 FY1920
592 100 2019-06-15 00:00:00 15 Saturday 6 June 1 0 No WK03 QTR 2019 FY1920
593 100 2019-06-16 00:00:00 16 Sunday 6 June 1 0 No WK03 QTR 2019 FY1920
594 100 2019-06-17 00:00:00 17 Monday 6 June 0 0 No WK03 QTR 2019 FY1920
595 100 2019-06-18 00:00:00 18 Tuesday 6 June 0 0 No WK03 QTR 2019 FY1920
596 100 2019-06-19 00:00:00 19 Wednesday 6 June 0 0 No WK03 QTR 2019 FY1920
597 100 2019-06-20 00:00:00 20 Thursday 6 June 0 0 No WK03 QTR 2019 FY1920
598 100 2019-06-21 00:00:00 21 Friday 6 June 0 0 No WK03 QTR 2019 FY1920
599 100 2019-06-22 00:00:00 22 Saturday 6 June 1 0 No WK04 QTR 2019 FY1920
600 100 2019-06-23 00:00:00 23 Sunday 6 June 1 0 No WK04 QTR 2019 FY1920
601 100 2019-06-24 00:00:00 24 Monday 6 June 0 0 No WK04 QTR 2019 FY1920
602 100 2019-06-25 00:00:00 25 Tuesday 6 June 0 0 No WK04 QTR 2019 FY1920
603 100 2019-06-26 00:00:00 26 Wednesday 6 June 0 0 No WK04 QTR 2019 FY1920
604 100 2019-06-27 00:00:00 27 Thursday 6 June 0 0 No WK04 QTR 2019 FY1920
605 100 2019-06-28 00:00:00 28 Friday 6 June 0 0 No WK04 QTR 2019 FY1920
606 100 2019-06-29 00:00:00 29 Saturday 6 June 1 0 No WK04 QTR 2019 FY1920
607 100 2019-06-30 00:00:00 30 Sunday 6 June 1 0 No WK04 QTR 2019 FY1920
608 100 2019-07-01 00:00:00 1 Monday 7 July 0 0 No WK01 QTR 2019 FY1920
609 100 2019-07-02 00:00:00 2 Tuesday 7 July 0 0 No WK01 QTR 2019 FY1920
610 100 2019-07-03 00:00:00 3 Wednesday 7 July 0 0 No WK01 QTR 2019 FY1920
611 100 2019-07-04 00:00:00 4 Thursday 7 July 0 0 No WK01 QTR 2019 FY1920
612 100 2019-07-05 00:00:00 5 Friday 7 July 0 0 No WK01 QTR 2019 FY1920
613 100 2019-07-06 00:00:00 6 Saturday 7 July 1 0 No WK01 QTR 2019 FY1920
614 100 2019-07-07 00:00:00 7 Sunday 7 July 1 0 No WK01 QTR 2019 FY1920
615 100 2019-07-08 00:00:00 8 Monday 7 July 0 0 No WK02 QTR 2019 FY1920
616 100 2019-07-09 00:00:00 9 Tuesday 7 July 0 0 No WK02 QTR 2019 FY1920
617 100 2019-07-10 00:00:00 10 Wednesday 7 July 0 0 No WK02 QTR 2019 FY1920
618 100 2019-07-11 00:00:00 11 Thursday 7 July 0 0 No WK02 QTR 2019 FY1920
619 100 2019-07-12 00:00:00 12 Friday 7 July 0 0 No WK02 QTR 2019 FY1920
620 100 2019-07-13 00:00:00 13 Saturday 7 July 1 0 No WK02 QTR 2019 FY1920
621 100 2019-07-14 00:00:00 14 Sunday 7 July 1 0 No WK02 QTR 2019 FY1920
622 100 2019-07-15 00:00:00 15 Monday 7 July 0 0 No WK03 QTR 2019 FY1920
623 100 2019-07-16 00:00:00 16 Tuesday 7 July 0 0 No WK03 QTR 2019 FY1920
624 100 2019-07-17 00:00:00 17 Wednesday 7 July 0 0 No WK03 QTR 2019 FY1920
625 100 2019-07-18 00:00:00 18 Thursday 7 July 0 0 No WK03 QTR 2019 FY1920
626 100 2019-07-19 00:00:00 19 Friday 7 July 0 0 No WK03 QTR 2019 FY1920
627 100 2019-07-20 00:00:00 20 Saturday 7 July 1 0 No WK03 QTR 2019 FY1920
628 100 2019-07-21 00:00:00 21 Sunday 7 July 1 0 No WK03 QTR 2019 FY1920
629 100 2019-07-22 00:00:00 22 Monday 7 July 0 0 No WK04 QTR 2019 FY1920
630 100 2019-07-23 00:00:00 23 Tuesday 7 July 0 0 No WK04 QTR 2019 FY1920
631 100 2019-07-24 00:00:00 24 Wednesday 7 July 0 0 No WK04 QTR 2019 FY1920
632 100 2019-07-25 00:00:00 25 Thursday 7 July 0 0 No WK04 QTR 2019 FY1920
633 100 2019-07-26 00:00:00 26 Friday 7 July 0 0 No WK04 QTR 2019 FY1920
634 100 2019-07-27 00:00:00 27 Saturday 7 July 1 0 No WK04 QTR 2019 FY1920
635 100 2019-07-28 00:00:00 28 Sunday 7 July 1 0 No WK04 QTR 2019 FY1920
636 100 2019-07-29 00:00:00 29 Monday 7 July 0 0 No WK04 QTR 2019 FY1920
637 100 2019-07-30 00:00:00 30 Tuesday 7 July 0 0 No WK04 QTR 2019 FY1920
638 100 2019-07-31 00:00:00 31 Wednesday 7 July 0 0 No WK QTR 2019 FY1920
639 100 2019-08-01 00:00:00 1 Thursday 8 August 0 0 No WK01 QTR 2019 FY1920
640 100 2019-08-02 00:00:00 2 Friday 8 August 0 0 No WK01 QTR 2019 FY1920
641 100 2019-08-03 00:00:00 3 Saturday 8 August 1 0 No WK01 QTR 2019 FY1920
642 100 2019-08-04 00:00:00 4 Sunday 8 August 1 0 No WK01 QTR 2019 FY1920
643 100 2019-08-05 00:00:00 5 Monday 8 August 0 0 No WK01 QTR 2019 FY1920
644 100 2019-08-06 00:00:00 6 Tuesday 8 August 0 0 No WK01 QTR 2019 FY1920
645 100 2019-08-07 00:00:00 7 Wednesday 8 August 0 0 No WK01 QTR 2019 FY1920
646 100 2019-08-08 00:00:00 8 Thursday 8 August 0 0 No WK02 QTR 2019 FY1920
647 100 2019-08-09 00:00:00 9 Friday 8 August 0 0 No WK02 QTR 2019 FY1920
648 100 2019-08-10 00:00:00 10 Saturday 8 August 1 0 No WK02 QTR 2019 FY1920
649 100 2019-08-11 00:00:00 11 Sunday 8 August 1 0 No WK02 QTR 2019 FY1920
650 100 2019-08-12 00:00:00 12 Monday 8 August 0 0 No WK02 QTR 2019 FY1920
651 100 2019-08-13 00:00:00 13 Tuesday 8 August 0 0 No WK02 QTR 2019 FY1920
652 100 2019-08-14 00:00:00 14 Wednesday 8 August 0 0 No WK02 QTR 2019 FY1920
653 100 2019-08-15 00:00:00 15 Thursday 8 August 0 0 No WK03 QTR 2019 FY1920
654 100 2019-08-16 00:00:00 16 Friday 8 August 0 0 No WK03 QTR 2019 FY1920
655 100 2019-08-17 00:00:00 17 Saturday 8 August 1 0 No WK03 QTR 2019 FY1920
656 100 2019-08-18 00:00:00 18 Sunday 8 August 1 0 No WK03 QTR 2019 FY1920
657 100 2019-08-19 00:00:00 19 Monday 8 August 0 0 No WK03 QTR 2019 FY1920
658 100 2019-08-20 00:00:00 20 Tuesday 8 August 0 0 No WK03 QTR 2019 FY1920
659 100 2019-08-21 00:00:00 21 Wednesday 8 August 0 0 No WK03 QTR 2019 FY1920
660 100 2019-08-22 00:00:00 22 Thursday 8 August 0 0 No WK04 QTR 2019 FY1920
661 100 2019-08-23 00:00:00 23 Friday 8 August 0 0 No WK04 QTR 2019 FY1920
662 100 2019-08-24 00:00:00 24 Saturday 8 August 1 0 No WK04 QTR 2019 FY1920
663 100 2019-08-25 00:00:00 25 Sunday 8 August 1 0 No WK04 QTR 2019 FY1920
664 100 2019-08-26 00:00:00 26 Monday 8 August 0 0 No WK04 QTR 2019 FY1920
665 100 2019-08-27 00:00:00 27 Tuesday 8 August 0 0 No WK04 QTR 2019 FY1920
666 100 2019-08-28 00:00:00 28 Wednesday 8 August 0 0 No WK04 QTR 2019 FY1920
667 100 2019-08-29 00:00:00 29 Thursday 8 August 0 0 No WK04 QTR 2019 FY1920
668 100 2019-08-30 00:00:00 30 Friday 8 August 0 0 No WK04 QTR 2019 FY1920
669 100 2019-08-31 00:00:00 31 Saturday 8 August 1 0 No WK QTR 2019 FY1920
670 100 2019-09-01 00:00:00 1 Sunday 9 September 1 0 No WK01 QTR 2019 FY1920
671 100 2019-09-02 00:00:00 2 Monday 9 September 0 0 No WK01 QTR 2019 FY1920
672 100 2019-09-03 00:00:00 3 Tuesday 9 September 0 0 No WK01 QTR 2019 FY1920
673 100 2019-09-04 00:00:00 4 Wednesday 9 September 0 0 No WK01 QTR 2019 FY1920
674 100 2019-09-05 00:00:00 5 Thursday 9 September 0 0 No WK01 QTR 2019 FY1920
675 100 2019-09-06 00:00:00 6 Friday 9 September 0 0 No WK01 QTR 2019 FY1920
676 100 2019-09-07 00:00:00 7 Saturday 9 September 1 0 No WK01 QTR 2019 FY1920
677 100 2019-09-08 00:00:00 8 Sunday 9 September 1 0 No WK02 QTR 2019 FY1920
678 100 2019-09-09 00:00:00 9 Monday 9 September 0 0 No WK02 QTR 2019 FY1920
679 100 2019-09-10 00:00:00 10 Tuesday 9 September 0 0 No WK02 QTR 2019 FY1920
680 100 2019-09-11 00:00:00 11 Wednesday 9 September 0 0 No WK02 QTR 2019 FY1920
681 100 2019-09-12 00:00:00 12 Thursday 9 September 0 0 No WK02 QTR 2019 FY1920
682 100 2019-09-13 00:00:00 13 Friday 9 September 0 0 No WK02 QTR 2019 FY1920
683 100 2019-09-14 00:00:00 14 Saturday 9 September 1 0 No WK02 QTR 2019 FY1920
684 100 2019-09-15 00:00:00 15 Sunday 9 September 1 0 No WK03 QTR 2019 FY1920
685 100 2019-09-16 00:00:00 16 Monday 9 September 0 0 No WK03 QTR 2019 FY1920
686 100 2019-09-17 00:00:00 17 Tuesday 9 September 0 0 No WK03 QTR 2019 FY1920
687 100 2019-09-18 00:00:00 18 Wednesday 9 September 0 0 No WK03 QTR 2019 FY1920
688 100 2019-09-19 00:00:00 19 Thursday 9 September 0 0 No WK03 QTR 2019 FY1920
689 100 2019-09-20 00:00:00 20 Friday 9 September 0 0 No WK03 QTR 2019 FY1920
690 100 2019-09-21 00:00:00 21 Saturday 9 September 1 0 No WK03 QTR 2019 FY1920
691 100 2019-09-22 00:00:00 22 Sunday 9 September 1 0 No WK04 QTR 2019 FY1920
692 100 2019-09-23 00:00:00 23 Monday 9 September 0 0 No WK04 QTR 2019 FY1920
693 100 2019-09-24 00:00:00 24 Tuesday 9 September 0 0 No WK04 QTR 2019 FY1920
694 100 2019-09-25 00:00:00 25 Wednesday 9 September 0 0 No WK04 QTR 2019 FY1920
695 100 2019-09-26 00:00:00 26 Thursday 9 September 0 0 No WK04 QTR 2019 FY1920
696 100 2019-09-27 00:00:00 27 Friday 9 September 0 0 No WK04 QTR 2019 FY1920
697 100 2019-09-28 00:00:00 28 Saturday 9 September 1 0 No WK04 QTR 2019 FY1920
698 100 2019-09-29 00:00:00 29 Sunday 9 September 1 0 No WK04 QTR 2019 FY1920
699 100 2019-09-30 00:00:00 30 Monday 9 September 0 0 No WK04 QTR 2019 FY1920
700 100 2019-10-01 00:00:00 1 Tuesday 10 October 0 0 No WK01 QTR 2019 FY1920
701 100 2019-10-02 00:00:00 2 Wednesday 10 October 0 0 No WK01 QTR 2019 FY1920
702 100 2019-10-03 00:00:00 3 Thursday 10 October 0 0 No WK01 QTR 2019 FY1920
703 100 2019-10-04 00:00:00 4 Friday 10 October 0 0 No WK01 QTR 2019 FY1920
704 100 2019-10-05 00:00:00 5 Saturday 10 October 1 0 No WK01 QTR 2019 FY1920
705 100 2019-10-06 00:00:00 6 Sunday 10 October 1 0 No WK01 QTR 2019 FY1920
706 100 2019-10-07 00:00:00 7 Monday 10 October 0 0 No WK01 QTR 2019 FY1920
707 100 2019-10-08 00:00:00 8 Tuesday 10 October 0 0 No WK02 QTR 2019 FY1920
708 100 2019-10-09 00:00:00 9 Wednesday 10 October 0 0 No WK02 QTR 2019 FY1920
709 100 2019-10-10 00:00:00 10 Thursday 10 October 0 0 No WK02 QTR 2019 FY1920
710 100 2019-10-11 00:00:00 11 Friday 10 October 0 0 No WK02 QTR 2019 FY1920
711 100 2019-10-12 00:00:00 12 Saturday 10 October 1 0 No WK02 QTR 2019 FY1920
712 100 2019-10-13 00:00:00 13 Sunday 10 October 1 0 No WK02 QTR 2019 FY1920
713 100 2019-10-14 00:00:00 14 Monday 10 October 0 0 No WK02 QTR 2019 FY1920
714 100 2019-10-15 00:00:00 15 Tuesday 10 October 0 0 No WK03 QTR 2019 FY1920
715 100 2019-10-16 00:00:00 16 Wednesday 10 October 0 0 No WK03 QTR 2019 FY1920
716 100 2019-10-17 00:00:00 17 Thursday 10 October 0 0 No WK03 QTR 2019 FY1920
717 100 2019-10-18 00:00:00 18 Friday 10 October 0 0 No WK03 QTR 2019 FY1920
718 100 2019-10-19 00:00:00 19 Saturday 10 October 1 0 No WK03 QTR 2019 FY1920
719 100 2019-10-20 00:00:00 20 Sunday 10 October 1 0 No WK03 QTR 2019 FY1920
720 100 2019-10-21 00:00:00 21 Monday 10 October 0 0 No WK03 QTR 2019 FY1920
721 100 2019-10-22 00:00:00 22 Tuesday 10 October 0 0 No WK04 QTR 2019 FY1920
722 100 2019-10-23 00:00:00 23 Wednesday 10 October 0 0 No WK04 QTR 2019 FY1920
723 100 2019-10-24 00:00:00 24 Thursday 10 October 0 0 No WK04 QTR 2019 FY1920
724 100 2019-10-25 00:00:00 25 Friday 10 October 0 0 No WK04 QTR 2019 FY1920
725 100 2019-10-26 00:00:00 26 Saturday 10 October 1 0 No WK04 QTR 2019 FY1920
726 100 2019-10-27 00:00:00 27 Sunday 10 October 1 0 No WK04 QTR 2019 FY1920
727 100 2019-10-28 00:00:00 28 Monday 10 October 0 0 No WK04 QTR 2019 FY1920
728 100 2019-10-29 00:00:00 29 Tuesday 10 October 0 0 No WK04 QTR 2019 FY1920
729 100 2019-10-30 00:00:00 30 Wednesday 10 October 0 0 No WK04 QTR 2019 FY1920
730 100 2019-10-31 00:00:00 31 Thursday 10 October 0 0 No WK QTR 2019 FY1920
731 100 2019-11-01 00:00:00 1 Friday 11 November 0 0 No WK01 QTR 2019 FY1920
732 100 2019-11-02 00:00:00 2 Saturday 11 November 1 0 No WK01 QTR 2019 FY1920
733 100 2019-11-03 00:00:00 3 Sunday 11 November 1 0 No WK01 QTR 2019 FY1920
734 100 2019-11-04 00:00:00 4 Monday 11 November 0 0 No WK01 QTR 2019 FY1920
735 100 2019-11-05 00:00:00 5 Tuesday 11 November 0 0 No WK01 QTR 2019 FY1920
736 100 2019-11-06 00:00:00 6 Wednesday 11 November 0 0 No WK01 QTR 2019 FY1920
737 100 2019-11-07 00:00:00 7 Thursday 11 November 0 0 No WK01 QTR 2019 FY1920
738 100 2019-11-08 00:00:00 8 Friday 11 November 0 0 No WK02 QTR 2019 FY1920
739 100 2019-11-09 00:00:00 9 Saturday 11 November 1 0 No WK02 QTR 2019 FY1920
740 100 2019-11-10 00:00:00 10 Sunday 11 November 1 0 No WK02 QTR 2019 FY1920
741 100 2019-11-11 00:00:00 11 Monday 11 November 0 0 No WK02 QTR 2019 FY1920
742 100 2019-11-12 00:00:00 12 Tuesday 11 November 0 0 No WK02 QTR 2019 FY1920
743 100 2019-11-13 00:00:00 13 Wednesday 11 November 0 0 No WK02 QTR 2019 FY1920
744 100 2019-11-14 00:00:00 14 Thursday 11 November 0 0 No WK02 QTR 2019 FY1920
745 100 2019-11-15 00:00:00 15 Friday 11 November 0 0 No WK03 QTR 2019 FY1920
746 100 2019-11-16 00:00:00 16 Saturday 11 November 1 0 No WK03 QTR 2019 FY1920
747 100 2019-11-17 00:00:00 17 Sunday 11 November 1 0 No WK03 QTR 2019 FY1920
748 100 2019-11-18 00:00:00 18 Monday 11 November 0 0 No WK03 QTR 2019 FY1920
749 100 2019-11-19 00:00:00 19 Tuesday 11 November 0 0 No WK03 QTR 2019 FY1920
750 100 2019-11-20 00:00:00 20 Wednesday 11 November 0 0 No WK03 QTR 2019 FY1920
751 100 2019-11-21 00:00:00 21 Thursday 11 November 0 0 No WK03 QTR 2019 FY1920
752 100 2019-11-22 00:00:00 22 Friday 11 November 0 0 No WK04 QTR 2019 FY1920
753 100 2019-11-23 00:00:00 23 Saturday 11 November 1 0 No WK04 QTR 2019 FY1920
754 100 2019-11-24 00:00:00 24 Sunday 11 November 1 0 No WK04 QTR 2019 FY1920
755 100 2019-11-25 00:00:00 25 Monday 11 November 0 0 No WK04 QTR 2019 FY1920
756 100 2019-11-26 00:00:00 26 Tuesday 11 November 0 0 No WK04 QTR 2019 FY1920
757 100 2019-11-27 00:00:00 27 Wednesday 11 November 0 0 No WK04 QTR 2019 FY1920
758 100 2019-11-28 00:00:00 28 Thursday 11 November 0 0 No WK04 QTR 2019 FY1920
759 100 2019-11-29 00:00:00 29 Friday 11 November 0 0 No WK04 QTR 2019 FY1920
760 100 2019-11-30 00:00:00 30 Saturday 11 November 1 0 No WK04 QTR 2019 FY1920
761 100 2019-12-01 00:00:00 1 Sunday 12 December 1 0 No WK01 QTR 2019 FY1920
762 100 2019-12-02 00:00:00 2 Monday 12 December 0 0 No WK01 QTR 2019 FY1920
763 100 2019-12-03 00:00:00 3 Tuesday 12 December 0 0 No WK01 QTR 2019 FY1920
764 100 2019-12-04 00:00:00 4 Wednesday 12 December 0 0 No WK01 QTR 2019 FY1920
765 100 2019-12-05 00:00:00 5 Thursday 12 December 0 0 No WK01 QTR 2019 FY1920
766 100 2019-12-06 00:00:00 6 Friday 12 December 0 0 No WK01 QTR 2019 FY1920
767 100 2019-12-07 00:00:00 7 Saturday 12 December 1 0 No WK01 QTR 2019 FY1920
768 100 2019-12-08 00:00:00 8 Sunday 12 December 1 0 No WK02 QTR 2019 FY1920
769 100 2019-12-09 00:00:00 9 Monday 12 December 0 0 No WK02 QTR 2019 FY1920
770 100 2019-12-10 00:00:00 10 Tuesday 12 December 0 0 No WK02 QTR 2019 FY1920
771 100 2019-12-11 00:00:00 11 Wednesday 12 December 0 0 No WK02 QTR 2019 FY1920
772 100 2019-12-12 00:00:00 12 Thursday 12 December 0 0 No WK02 QTR 2019 FY1920
773 100 2019-12-13 00:00:00 13 Friday 12 December 0 0 No WK02 QTR 2019 FY1920
774 100 2019-12-14 00:00:00 14 Saturday 12 December 1 0 No WK02 QTR 2019 FY1920
775 100 2019-12-15 00:00:00 15 Sunday 12 December 1 0 No WK03 QTR 2019 FY1920
776 100 2019-12-16 00:00:00 16 Monday 12 December 0 0 No WK03 QTR 2019 FY1920
777 100 2019-12-17 00:00:00 17 Tuesday 12 December 0 0 No WK03 QTR 2019 FY1920
778 100 2019-12-18 00:00:00 18 Wednesday 12 December 0 0 No WK03 QTR 2019 FY1920
779 100 2019-12-19 00:00:00 19 Thursday 12 December 0 0 No WK03 QTR 2019 FY1920
780 100 2019-12-20 00:00:00 20 Friday 12 December 0 0 No WK03 QTR 2019 FY1920
781 100 2019-12-21 00:00:00 21 Saturday 12 December 1 0 No WK03 QTR 2019 FY1920
782 100 2019-12-22 00:00:00 22 Sunday 12 December 1 0 No WK04 QTR 2019 FY1920
783 100 2019-12-23 00:00:00 23 Monday 12 December 0 0 No WK04 QTR 2019 FY1920
784 100 2019-12-24 00:00:00 24 Tuesday 12 December 0 0 No WK04 QTR 2019 FY1920
785 100 2019-12-25 00:00:00 25 Wednesday 12 December 0 0 No WK04 QTR 2019 FY1920
786 100 2019-12-26 00:00:00 26 Thursday 12 December 0 0 No WK04 QTR 2019 FY1920
787 100 2019-12-27 00:00:00 27 Friday 12 December 0 0 No WK04 QTR 2019 FY1920
788 100 2019-12-28 00:00:00 28 Saturday 12 December 1 0 No WK04 QTR 2019 FY1920
789 100 2019-12-29 00:00:00 29 Sunday 12 December 1 0 No WK04 QTR 2019 FY1920
790 100 2019-12-30 00:00:00 30 Monday 12 December 0 0 No WK04 QTR 2019 FY1920
791 100 2019-12-31 00:00:00 31 Tuesday 12 December 0 0 No WK QTR 2019 FY1920
792 100 2020-01-01 00:00:00 1 Wednesday 1 January 0 0 No WK01 QTR 2020 FY2021
793 100 2020-01-02 00:00:00 2 Thursday 1 January 0 0 No WK01 QTR 2020 FY2021
794 100 2020-01-03 00:00:00 3 Friday 1 January 0 0 No WK01 QTR 2020 FY2021
795 100 2020-01-04 00:00:00 4 Saturday 1 January 1 0 No WK01 QTR 2020 FY2021
796 100 2020-01-05 00:00:00 5 Sunday 1 January 1 0 No WK01 QTR 2020 FY2021
797 100 2020-01-06 00:00:00 6 Monday 1 January 0 0 No WK01 QTR 2020 FY2021
798 100 2020-01-07 00:00:00 7 Tuesday 1 January 0 0 No WK01 QTR 2020 FY2021
799 100 2020-01-08 00:00:00 8 Wednesday 1 January 0 0 No WK02 QTR 2020 FY2021
800 100 2020-01-09 00:00:00 9 Thursday 1 January 0 0 No WK02 QTR 2020 FY2021
801 100 2020-01-10 00:00:00 10 Friday 1 January 0 0 No WK02 QTR 2020 FY2021
802 100 2020-01-11 00:00:00 11 Saturday 1 January 1 0 No WK02 QTR 2020 FY2021
803 100 2020-01-12 00:00:00 12 Sunday 1 January 1 0 No WK02 QTR 2020 FY2021
804 100 2020-01-13 00:00:00 13 Monday 1 January 0 0 No WK02 QTR 2020 FY2021
805 100 2020-01-14 00:00:00 14 Tuesday 1 January 0 0 No WK02 QTR 2020 FY2021
806 100 2020-01-15 00:00:00 15 Wednesday 1 January 0 0 No WK03 QTR 2020 FY2021
807 100 2020-01-16 00:00:00 16 Thursday 1 January 0 0 No WK03 QTR 2020 FY2021
808 100 2020-01-17 00:00:00 17 Friday 1 January 0 0 No WK03 QTR 2020 FY2021
809 100 2020-01-18 00:00:00 18 Saturday 1 January 1 0 No WK03 QTR 2020 FY2021
810 100 2020-01-19 00:00:00 19 Sunday 1 January 1 0 No WK03 QTR 2020 FY2021
811 100 2020-01-20 00:00:00 20 Monday 1 January 0 0 No WK03 QTR 2020 FY2021
812 100 2020-01-21 00:00:00 21 Tuesday 1 January 0 0 No WK03 QTR 2020 FY2021
813 100 2020-01-22 00:00:00 22 Wednesday 1 January 0 0 No WK04 QTR 2020 FY2021
814 100 2020-01-23 00:00:00 23 Thursday 1 January 0 0 No WK04 QTR 2020 FY2021
815 100 2020-01-24 00:00:00 24 Friday 1 January 0 0 No WK04 QTR 2020 FY2021
816 100 2020-01-25 00:00:00 25 Saturday 1 January 1 0 No WK04 QTR 2020 FY2021
817 100 2020-01-26 00:00:00 26 Sunday 1 January 1 0 No WK04 QTR 2020 FY2021
818 100 2020-01-27 00:00:00 27 Monday 1 January 0 0 No WK04 QTR 2020 FY2021
819 100 2020-01-28 00:00:00 28 Tuesday 1 January 0 0 No WK04 QTR 2020 FY2021
820 100 2020-01-29 00:00:00 29 Wednesday 1 January 0 0 No WK04 QTR 2020 FY2021
821 100 2020-01-30 00:00:00 30 Thursday 1 January 0 0 No WK04 QTR 2020 FY2021
822 100 2020-01-31 00:00:00 31 Friday 1 January 0 0 No WK QTR 2020 FY2021
823 100 2020-02-01 00:00:00 1 Saturday 2 February 1 0 No WK01 QTR 2020 FY2021
824 100 2020-02-02 00:00:00 2 Sunday 2 February 1 0 No WK01 QTR 2020 FY2021
825 100 2020-02-03 00:00:00 3 Monday 2 February 0 0 No WK01 QTR 2020 FY2021
826 100 2020-02-04 00:00:00 4 Tuesday 2 February 0 0 No WK01 QTR 2020 FY2021
827 100 2020-02-05 00:00:00 5 Wednesday 2 February 0 0 No WK01 QTR 2020 FY2021
828 100 2020-02-06 00:00:00 6 Thursday 2 February 0 0 No WK01 QTR 2020 FY2021
829 100 2020-02-07 00:00:00 7 Friday 2 February 0 0 No WK01 QTR 2020 FY2021
830 100 2020-02-08 00:00:00 8 Saturday 2 February 1 0 No WK02 QTR 2020 FY2021
831 100 2020-02-09 00:00:00 9 Sunday 2 February 1 0 No WK02 QTR 2020 FY2021
832 100 2020-02-10 00:00:00 10 Monday 2 February 0 0 No WK02 QTR 2020 FY2021
833 100 2020-02-11 00:00:00 11 Tuesday 2 February 0 0 No WK02 QTR 2020 FY2021
834 100 2020-02-12 00:00:00 12 Wednesday 2 February 0 0 No WK02 QTR 2020 FY2021
835 100 2020-02-13 00:00:00 13 Thursday 2 February 0 0 No WK02 QTR 2020 FY2021
836 100 2020-02-14 00:00:00 14 Friday 2 February 0 0 No WK02 QTR 2020 FY2021
837 100 2020-02-15 00:00:00 15 Saturday 2 February 1 0 No WK03 QTR 2020 FY2021
838 100 2020-02-16 00:00:00 16 Sunday 2 February 1 0 No WK03 QTR 2020 FY2021
839 100 2020-02-17 00:00:00 17 Monday 2 February 0 0 No WK03 QTR 2020 FY2021
840 100 2020-02-18 00:00:00 18 Tuesday 2 February 0 0 No WK03 QTR 2020 FY2021
841 100 2020-02-19 00:00:00 19 Wednesday 2 February 0 0 No WK03 QTR 2020 FY2021
842 100 2020-02-20 00:00:00 20 Thursday 2 February 0 0 No WK03 QTR 2020 FY2021
843 100 2020-02-21 00:00:00 21 Friday 2 February 0 0 No WK03 QTR 2020 FY2021
844 100 2020-02-22 00:00:00 22 Saturday 2 February 1 0 No WK04 QTR 2020 FY2021
845 100 2020-02-23 00:00:00 23 Sunday 2 February 1 0 No WK04 QTR 2020 FY2021
846 100 2020-02-24 00:00:00 24 Monday 2 February 0 0 No WK04 QTR 2020 FY2021
847 100 2020-02-25 00:00:00 25 Tuesday 2 February 0 0 No WK04 QTR 2020 FY2021
848 100 2020-02-26 00:00:00 26 Wednesday 2 February 0 0 No WK04 QTR 2020 FY2021
849 100 2020-02-27 00:00:00 27 Thursday 2 February 0 0 No WK04 QTR 2020 FY2021
850 100 2020-02-28 00:00:00 28 Friday 2 February 0 0 No WK04 QTR 2020 FY2021
851 100 2020-02-29 00:00:00 29 Saturday 2 February 1 0 No WK04 QTR 2020 FY2021
852 100 2020-03-01 00:00:00 1 Sunday 3 March 1 0 No WK01 QTR 2020 FY2021
853 100 2020-03-02 00:00:00 2 Monday 3 March 0 0 No WK01 QTR 2020 FY2021
854 100 2020-03-03 00:00:00 3 Tuesday 3 March 0 0 No WK01 QTR 2020 FY2021
855 100 2020-03-04 00:00:00 4 Wednesday 3 March 0 0 No WK01 QTR 2020 FY2021
856 100 2020-03-05 00:00:00 5 Thursday 3 March 0 0 No WK01 QTR 2020 FY2021
857 100 2020-03-06 00:00:00 6 Friday 3 March 0 0 No WK01 QTR 2020 FY2021
858 100 2020-03-07 00:00:00 7 Saturday 3 March 1 0 No WK01 QTR 2020 FY2021
859 100 2020-03-08 00:00:00 8 Sunday 3 March 1 0 No WK02 QTR 2020 FY2021
860 100 2020-03-09 00:00:00 9 Monday 3 March 0 0 No WK02 QTR 2020 FY2021
861 100 2020-03-10 00:00:00 10 Tuesday 3 March 0 0 No WK02 QTR 2020 FY2021
862 100 2020-03-11 00:00:00 11 Wednesday 3 March 0 0 No WK02 QTR 2020 FY2021
863 100 2020-03-12 00:00:00 12 Thursday 3 March 0 0 No WK02 QTR 2020 FY2021
864 100 2020-03-13 00:00:00 13 Friday 3 March 0 0 No WK02 QTR 2020 FY2021
865 100 2020-03-14 00:00:00 14 Saturday 3 March 1 0 No WK02 QTR 2020 FY2021
866 100 2020-03-15 00:00:00 15 Sunday 3 March 1 0 No WK03 QTR 2020 FY2021
867 100 2020-03-16 00:00:00 16 Monday 3 March 0 0 No WK03 QTR 2020 FY2021
868 100 2020-03-17 00:00:00 17 Tuesday 3 March 0 0 No WK03 QTR 2020 FY2021
869 100 2020-03-18 00:00:00 18 Wednesday 3 March 0 0 No WK03 QTR 2020 FY2021
870 100 2020-03-19 00:00:00 19 Thursday 3 March 0 0 No WK03 QTR 2020 FY2021
871 100 2020-03-20 00:00:00 20 Friday 3 March 0 0 No WK03 QTR 2020 FY2021
872 100 2020-03-21 00:00:00 21 Saturday 3 March 1 0 No WK03 QTR 2020 FY2021
873 100 2020-03-22 00:00:00 22 Sunday 3 March 1 0 No WK04 QTR 2020 FY2021
874 100 2020-03-23 00:00:00 23 Monday 3 March 0 0 No WK04 QTR 2020 FY2021
875 100 2020-03-24 00:00:00 24 Tuesday 3 March 0 0 No WK04 QTR 2020 FY2021
876 100 2020-03-25 00:00:00 25 Wednesday 3 March 0 0 No WK04 QTR 2020 FY2021
877 100 2020-03-26 00:00:00 26 Thursday 3 March 0 0 No WK04 QTR 2020 FY2021
878 100 2020-03-27 00:00:00 27 Friday 3 March 0 0 No WK04 QTR 2020 FY2021
879 100 2020-03-28 00:00:00 28 Saturday 3 March 1 0 No WK04 QTR 2020 FY2021
880 100 2020-03-29 00:00:00 29 Sunday 3 March 1 0 No WK04 QTR 2020 FY2021
881 100 2020-03-30 00:00:00 30 Monday 3 March 0 0 No WK04 QTR 2020 FY2021
882 100 2020-03-31 00:00:00 31 Tuesday 3 March 0 0 No WK QTR 2020 FY2021
883 100 2020-04-01 00:00:00 1 Wednesday 4 April 0 0 No WK01 QTR 2020 FY2021
884 100 2020-04-02 00:00:00 2 Thursday 4 April 0 0 No WK01 QTR 2020 FY2021
885 100 2020-04-03 00:00:00 3 Friday 4 April 0 0 No WK01 QTR 2020 FY2021
886 100 2020-04-04 00:00:00 4 Saturday 4 April 1 0 No WK01 QTR 2020 FY2021
887 100 2020-04-05 00:00:00 5 Sunday 4 April 1 0 No WK01 QTR 2020 FY2021
888 100 2020-04-06 00:00:00 6 Monday 4 April 0 0 No WK01 QTR 2020 FY2021
889 100 2020-04-07 00:00:00 7 Tuesday 4 April 0 0 No WK01 QTR 2020 FY2021
890 100 2020-04-08 00:00:00 8 Wednesday 4 April 0 0 No WK02 QTR 2020 FY2021
891 100 2020-04-09 00:00:00 9 Thursday 4 April 0 0 No WK02 QTR 2020 FY2021
892 100 2020-04-10 00:00:00 10 Friday 4 April 0 0 No WK02 QTR 2020 FY2021
893 100 2020-04-11 00:00:00 11 Saturday 4 April 1 0 No WK02 QTR 2020 FY2021
894 100 2020-04-12 00:00:00 12 Sunday 4 April 1 0 No WK02 QTR 2020 FY2021
895 100 2020-04-13 00:00:00 13 Monday 4 April 0 0 No WK02 QTR 2020 FY2021
896 100 2020-04-14 00:00:00 14 Tuesday 4 April 0 0 No WK02 QTR 2020 FY2021
897 100 2020-04-15 00:00:00 15 Wednesday 4 April 0 0 No WK03 QTR 2020 FY2021
898 100 2020-04-16 00:00:00 16 Thursday 4 April 0 0 No WK03 QTR 2020 FY2021
899 100 2020-04-17 00:00:00 17 Friday 4 April 0 0 No WK03 QTR 2020 FY2021
900 100 2020-04-18 00:00:00 18 Saturday 4 April 1 0 No WK03 QTR 2020 FY2021
901 100 2020-04-19 00:00:00 19 Sunday 4 April 1 0 No WK03 QTR 2020 FY2021
902 100 2020-04-20 00:00:00 20 Monday 4 April 0 0 No WK03 QTR 2020 FY2021
903 100 2020-04-21 00:00:00 21 Tuesday 4 April 0 0 No WK03 QTR 2020 FY2021
904 100 2020-04-22 00:00:00 22 Wednesday 4 April 0 0 No WK04 QTR 2020 FY2021
905 100 2020-04-23 00:00:00 23 Thursday 4 April 0 0 No WK04 QTR 2020 FY2021
906 100 2020-04-24 00:00:00 24 Friday 4 April 0 0 No WK04 QTR 2020 FY2021
907 100 2020-04-25 00:00:00 25 Saturday 4 April 1 0 No WK04 QTR 2020 FY2021
908 100 2020-04-26 00:00:00 26 Sunday 4 April 1 0 No WK04 QTR 2020 FY2021
909 100 2020-04-27 00:00:00 27 Monday 4 April 0 0 No WK04 QTR 2020 FY2021
910 100 2020-04-28 00:00:00 28 Tuesday 4 April 0 0 No WK04 QTR 2020 FY2021
911 100 2020-04-29 00:00:00 29 Wednesday 4 April 0 0 No WK04 QTR 2020 FY2021
912 100 2020-04-30 00:00:00 30 Thursday 4 April 0 0 No WK04 QTR 2020 FY2021
913 100 2020-05-01 00:00:00 1 Friday 5 May 0 0 No WK01 QTR 2020 FY2021
914 100 2020-05-02 00:00:00 2 Saturday 5 May 1 0 No WK01 QTR 2020 FY2021
915 100 2020-05-03 00:00:00 3 Sunday 5 May 1 0 No WK01 QTR 2020 FY2021
916 100 2020-05-04 00:00:00 4 Monday 5 May 0 0 No WK01 QTR 2020 FY2021
917 100 2020-05-05 00:00:00 5 Tuesday 5 May 0 0 No WK01 QTR 2020 FY2021
918 100 2020-05-06 00:00:00 6 Wednesday 5 May 0 0 No WK01 QTR 2020 FY2021
919 100 2020-05-07 00:00:00 7 Thursday 5 May 0 0 No WK01 QTR 2020 FY2021
920 100 2020-05-08 00:00:00 8 Friday 5 May 0 0 No WK02 QTR 2020 FY2021
921 100 2020-05-09 00:00:00 9 Saturday 5 May 1 0 No WK02 QTR 2020 FY2021
922 100 2020-05-10 00:00:00 10 Sunday 5 May 1 0 No WK02 QTR 2020 FY2021
923 100 2020-05-11 00:00:00 11 Monday 5 May 0 0 No WK02 QTR 2020 FY2021
924 100 2020-05-12 00:00:00 12 Tuesday 5 May 0 0 No WK02 QTR 2020 FY2021
925 100 2020-05-13 00:00:00 13 Wednesday 5 May 0 0 No WK02 QTR 2020 FY2021
926 100 2020-05-14 00:00:00 14 Thursday 5 May 0 0 No WK02 QTR 2020 FY2021
927 100 2020-05-15 00:00:00 15 Friday 5 May 0 0 No WK03 QTR 2020 FY2021
928 100 2020-05-16 00:00:00 16 Saturday 5 May 1 0 No WK03 QTR 2020 FY2021
929 100 2020-05-17 00:00:00 17 Sunday 5 May 1 0 No WK03 QTR 2020 FY2021
930 100 2020-05-18 00:00:00 18 Monday 5 May 0 0 No WK03 QTR 2020 FY2021
931 100 2020-05-19 00:00:00 19 Tuesday 5 May 0 0 No WK03 QTR 2020 FY2021
932 100 2020-05-20 00:00:00 20 Wednesday 5 May 0 0 No WK03 QTR 2020 FY2021
933 100 2020-05-21 00:00:00 21 Thursday 5 May 0 0 No WK03 QTR 2020 FY2021
934 100 2020-05-22 00:00:00 22 Friday 5 May 0 0 No WK04 QTR 2020 FY2021
935 100 2020-05-23 00:00:00 23 Saturday 5 May 1 0 No WK04 QTR 2020 FY2021
936 100 2020-05-24 00:00:00 24 Sunday 5 May 1 0 No WK04 QTR 2020 FY2021
937 100 2020-05-25 00:00:00 25 Monday 5 May 0 0 No WK04 QTR 2020 FY2021
938 100 2020-05-26 00:00:00 26 Tuesday 5 May 0 0 No WK04 QTR 2020 FY2021
939 100 2020-05-27 00:00:00 27 Wednesday 5 May 0 0 No WK04 QTR 2020 FY2021
940 100 2020-05-28 00:00:00 28 Thursday 5 May 0 0 No WK04 QTR 2020 FY2021
941 100 2020-05-29 00:00:00 29 Friday 5 May 0 0 No WK04 QTR 2020 FY2021
942 100 2020-05-30 00:00:00 30 Saturday 5 May 1 0 No WK04 QTR 2020 FY2021
943 100 2020-05-31 00:00:00 31 Sunday 5 May 1 0 No WK QTR 2020 FY2021
944 100 2020-06-01 00:00:00 1 Monday 6 June 0 0 No WK01 QTR 2020 FY2021
945 100 2020-06-02 00:00:00 2 Tuesday 6 June 0 0 No WK01 QTR 2020 FY2021
946 100 2020-06-03 00:00:00 3 Wednesday 6 June 0 0 No WK01 QTR 2020 FY2021
947 100 2020-06-04 00:00:00 4 Thursday 6 June 0 0 No WK01 QTR 2020 FY2021
948 100 2020-06-05 00:00:00 5 Friday 6 June 0 0 No WK01 QTR 2020 FY2021
949 100 2020-06-06 00:00:00 6 Saturday 6 June 1 0 No WK01 QTR 2020 FY2021
950 100 2020-06-07 00:00:00 7 Sunday 6 June 1 0 No WK01 QTR 2020 FY2021
951 100 2020-06-08 00:00:00 8 Monday 6 June 0 0 No WK02 QTR 2020 FY2021
952 100 2020-06-09 00:00:00 9 Tuesday 6 June 0 0 No WK02 QTR 2020 FY2021
953 100 2020-06-10 00:00:00 10 Wednesday 6 June 0 0 No WK02 QTR 2020 FY2021
954 100 2020-06-11 00:00:00 11 Thursday 6 June 0 0 No WK02 QTR 2020 FY2021
955 100 2020-06-12 00:00:00 12 Friday 6 June 0 0 No WK02 QTR 2020 FY2021
956 100 2020-06-13 00:00:00 13 Saturday 6 June 1 0 No WK02 QTR 2020 FY2021
957 100 2020-06-14 00:00:00 14 Sunday 6 June 1 0 No WK02 QTR 2020 FY2021
958 100 2020-06-15 00:00:00 15 Monday 6 June 0 0 No WK03 QTR 2020 FY2021
959 100 2020-06-16 00:00:00 16 Tuesday 6 June 0 0 No WK03 QTR 2020 FY2021
960 100 2020-06-17 00:00:00 17 Wednesday 6 June 0 0 No WK03 QTR 2020 FY2021
961 100 2020-06-18 00:00:00 18 Thursday 6 June 0 0 No WK03 QTR 2020 FY2021
962 100 2020-06-19 00:00:00 19 Friday 6 June 0 0 No WK03 QTR 2020 FY2021
963 100 2020-06-20 00:00:00 20 Saturday 6 June 1 0 No WK03 QTR 2020 FY2021
964 100 2020-06-21 00:00:00 21 Sunday 6 June 1 0 No WK03 QTR 2020 FY2021
965 100 2020-06-22 00:00:00 22 Monday 6 June 0 0 No WK04 QTR 2020 FY2021
966 100 2020-06-23 00:00:00 23 Tuesday 6 June 0 0 No WK04 QTR 2020 FY2021
967 100 2020-06-24 00:00:00 24 Wednesday 6 June 0 0 No WK04 QTR 2020 FY2021
968 100 2020-06-25 00:00:00 25 Thursday 6 June 0 0 No WK04 QTR 2020 FY2021
969 100 2020-06-26 00:00:00 26 Friday 6 June 0 0 No WK04 QTR 2020 FY2021
970 100 2020-06-27 00:00:00 27 Saturday 6 June 1 0 No WK04 QTR 2020 FY2021
971 100 2020-06-28 00:00:00 28 Sunday 6 June 1 0 No WK04 QTR 2020 FY2021
972 100 2020-06-29 00:00:00 29 Monday 6 June 0 0 No WK04 QTR 2020 FY2021
973 100 2020-06-30 00:00:00 30 Tuesday 6 June 0 0 No WK04 QTR 2020 FY2021
(973 row(s) affected)
btw, as long as you don't use SQL Server 2005-, this is wrong:
it must be
same for the other date suffixed columns.
And if it is a dimensional table, I strongly recommend Kimball's books.
And last, but not least: Your table defines fiscal values, but it does not correlate them with the normal date. FiscalDate <> NormalDate and there is no further date column for this. Even dimensional tables require correct naming schemes.
FiscalDate - Smalldatetime - Ex: 11/24/2017
it must be
FiscalDate DATE NOT NULL
same for the other date suffixed columns.
And if it is a dimensional table, I strongly recommend Kimball's books.
And last, but not least: Your table defines fiscal values, but it does not correlate them with the normal date. FiscalDate <> NormalDate and there is no further date column for this. Even dimensional tables require correct naming schemes.
@ste5an
Below is working fine for me in SQL 2012+ so why to use Date type.
DECLARE @StartDate smalldatetime = '11/01/2017'
Below is working fine for me in SQL 2012+ so why to use Date type.
DECLARE @StartDate smalldatetime = '11/01/2017'
It's not about working, it's about data modelling, domain and naming. A column suffixed with Date having a data type other than DATE is semantically wrong.
It also has a time portion, which requires additional checks and more carful handling when used in queries.
And for more semantics: a fiscal year is something different than a fiscal calendar, like 4-4-5 or 12-30. The above one look like normal calendar dimensions for different fiscal years.
It also has a time portion, which requires additional checks and more carful handling when used in queries.
And for more semantics: a fiscal year is something different than a fiscal calendar, like 4-4-5 or 12-30. The above one look like normal calendar dimensions for different fiscal years.
ASKER
@Pawan - Week numbers are still wrong.
1. date 31 for any month - week number is missing
2. each week should only have a max of 7 days. your approach would give more than that. Logic should be to take sun as 1 to sat as 7 and make the week's accordingly.
3. fiscalyearpercalendar is still wrong. for ex: if fiscalstart is july. then fiscal year is from 1st July 2017 to 30th June 2018. Till this period, fiscalyearpercalendar should be FY1718 and for next cycle it should be FY1819 and so on.
4. because week's logic is incorrect, quarter also fails in numbering.
1. date 31 for any month - week number is missing
2. each week should only have a max of 7 days. your approach would give more than that. Logic should be to take sun as 1 to sat as 7 and make the week's accordingly.
3. fiscalyearpercalendar is still wrong. for ex: if fiscalstart is july. then fiscal year is from 1st July 2017 to 30th June 2018. Till this period, fiscalyearpercalendar should be FY1718 and for next cycle it should be FY1819 and so on.
4. because week's logic is incorrect, quarter also fails in numbering.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@Pawan - Qtr is not right as your query gives qtr number only for 1718. Nonetheless, I am handling this with Update query. Thanks for your help.