Home » SQL & PL/SQL » SQL & PL/SQL » getting finacial week number (oracle 11gr2)
getting finacial week number [message #612379] |
Thu, 17 April 2014 06:09 |
|
guddu_12
Messages: 227 Registered: April 2012 Location: UK
|
Senior Member |
|
|
Dear All,
I want to populate week number into table for financial year '2014-15' which start from 01-apr-2014 and end on 31-03-2015.
the to_char(date,'ww') do not give appropriate answer as it start from 01-jan where as i want it to start form 01-apr-2014.
How can i achive the running week number from 01-apr-2014 to 31-mar-2015.
|
|
|
|
|
|
Re: getting finacial week number [message #612384 is a reply to message #612380] |
Thu, 17 April 2014 07:21 |
|
dariyoosh
Messages: 538 Registered: March 2009 Location: France
|
Senior Member |
|
|
Solomon Yakobson wrote on Thu, 17 April 2014 13:17CEIL((DT - DATE '2014-04-01') / 7)
SY.
Assuming that the year starts on the 1st April 2014 and week numbering is based on ISO, therefore, Monday being the first day of the week and Sunday the end of the week, then I think what you suggest with CEIL will not work as each Monday will have the same week number as the previous week. I think for this problem TRUNC(...)+1 should be used rather than CEIL. The following is a date generator for the whole period, indicating the difference between the result of the CEIL and TRUNC in terms of week numbering.
set linesize 300
alter session set nls_date_format = 'yyyy-mm-dd';
column day_name format a15
--
select
date '2014-04-01' + (level - 1) dateval,
to_char(date '2014-04-01' + (level - 1), 'day') day_name,
to_char(date '2014-04-01' + (level - 1), 'd') day_of_week,
trunc(level / 7)+1 week_number_trunc,
ceil(level / 7) week_number_ceil
from
"PUBLIC".dual
connect by
level <= date '2015-03-31' - date '2014-04-01' + 1;
And if you compare the 4th and 5th column of the following output for each Monday you can see the difference in terms of the week numbering.
DATEVAL DAY_NAME D WEEK_NUMBER_TRUNC WEEK_NUMBER_CEIL
---------- --------------- - ----------------- ----------------
2014-04-01 tuesday 3 1 1
2014-04-02 wednesday 4 1 1
2014-04-03 thursday 5 1 1
2014-04-04 friday 6 1 1
2014-04-05 saturday 7 1 1
2014-04-06 sunday 1 1 1
2014-04-07 monday 2 2 1
2014-04-08 tuesday 3 2 2
2014-04-09 wednesday 4 2 2
2014-04-10 thursday 5 2 2
2014-04-11 friday 6 2 2
DATEVAL DAY_NAME D WEEK_NUMBER_TRUNC WEEK_NUMBER_CEIL
---------- --------------- - ----------------- ----------------
2014-04-12 saturday 7 2 2
2014-04-13 sunday 1 2 2
2014-04-14 monday 2 3 2
2014-04-15 tuesday 3 3 3
2014-04-16 wednesday 4 3 3
2014-04-17 thursday 5 3 3
2014-04-18 friday 6 3 3
2014-04-19 saturday 7 3 3
2014-04-20 sunday 1 3 3
2014-04-21 monday 2 4 3
2014-04-22 tuesday 3 4 4
DATEVAL DAY_NAME D WEEK_NUMBER_TRUNC WEEK_NUMBER_CEIL
---------- --------------- - ----------------- ----------------
2014-04-23 wednesday 4 4 4
2014-04-24 thursday 5 4 4
2014-04-25 friday 6 4 4
2014-04-26 saturday 7 4 4
2014-04-27 sunday 1 4 4
2014-04-28 monday 2 5 4
2014-04-29 tuesday 3 5 5
2014-04-30 wednesday 4 5 5
2014-05-01 thursday 5 5 5
2014-05-02 friday 6 5 5
2014-05-03 saturday 7 5 5
DATEVAL DAY_NAME D WEEK_NUMBER_TRUNC WEEK_NUMBER_CEIL
---------- --------------- - ----------------- ----------------
2014-05-04 sunday 1 5 5
2014-05-05 monday 2 6 5
2014-05-06 tuesday 3 6 6
2014-05-07 wednesday 4 6 6
2014-05-08 thursday 5 6 6
2014-05-09 friday 6 6 6
2014-05-10 saturday 7 6 6
2014-05-11 sunday 1 6 6
2014-05-12 monday 2 7 6
2014-05-13 tuesday 3 7 7
2014-05-14 wednesday 4 7 7
DATEVAL DAY_NAME D WEEK_NUMBER_TRUNC WEEK_NUMBER_CEIL
---------- --------------- - ----------------- ----------------
2014-05-15 thursday 5 7 7
2014-05-16 friday 6 7 7
2014-05-17 saturday 7 7 7
2014-05-18 sunday 1 7 7
2014-05-19 monday 2 8 7
2014-05-20 tuesday 3 8 8
2014-05-21 wednesday 4 8 8
2014-05-22 thursday 5 8 8
2014-05-23 friday 6 8 8
2014-05-24 saturday 7 8 8
2014-05-25 sunday 1 8 8
DATEVAL DAY_NAME D WEEK_NUMBER_TRUNC WEEK_NUMBER_CEIL
---------- --------------- - ----------------- ----------------
2014-05-26 monday 2 9 8
2014-05-27 tuesday 3 9 9
2014-05-28 wednesday 4 9 9
2014-05-29 thursday 5 9 9
2014-05-30 friday 6 9 9
2014-05-31 saturday 7 9 9
2014-06-01 sunday 1 9 9
2014-06-02 monday 2 10 9
2014-06-03 tuesday 3 10 10
2014-06-04 wednesday 4 10 10
2014-06-05 thursday 5 10 10
.
.
.
[Updated on: Thu, 17 April 2014 07:29] Report message to a moderator
|
|
|
|
Re: getting finacial week number [message #612393 is a reply to message #612384] |
Thu, 17 April 2014 09:24 |
Solomon Yakobson
Messages: 3275 Registered: January 2010 Location: Connecticut, USA
|
Senior Member |
|
|
dariyoosh wrote on Thu, 17 April 2014 08:21And if you compare the 4th and 5th column of the following output for each Monday you can see the difference in terms of the week numbering.
Solution I posted assumes week 1 of fiscal year starts April 1. Your solution is totally wrong. The only reason it shows correct results for 2014 is April 1 is Tuesday. Look what happens for 2016:
select
date '2016-04-01' + (level - 1) dateval,
to_char(date '2016-04-01' + (level - 1), 'day') day_name,
to_char(date '2016-04-01' + (level - 1), 'd') day_of_week,
trunc(level / 7)+1 week_number_trunc,
ceil(level / 7) week_number_ceil
from
"PUBLIC".dual
connect by
level <= date '2017-04-30' - date '2016-04-01' + 1
/
DATEVAL DAY_NAME D WEEK_NUMBER_TRUNC WEEK_NUMBER_CEIL
---------- --------------- - ----------------- ----------------
2016-04-01 friday 6 1 1
2016-04-02 saturday 7 1 1
2016-04-03 sunday 1 1 1
2016-04-04 monday 2 1 1
2016-04-05 tuesday 3 1 1
2016-04-06 wednesday 4 1 1
2016-04-07 thursday 5 2 1
2016-04-08 friday 6 2 2
2016-04-09 saturday 7 2 2
2016-04-10 sunday 1 2 2
2016-04-11 monday 2 2 2
Now your week 2 starts Thursday. Also, your query will continue week numbering if connect by spans multiple fiscal years while we need to reset week numer to 1. If week starts monday:
CEIL((DT - TRUNC(ADD_MONTHS(TRUNC(ADD_MONTHS(DT,-3),'YY'),3),'IW') + 1) / 7)
For example:
WITH T AS (
SELECT DATE '2016-03-31' + LEVEL DT
FROM DUAL
CONNECT BY LEVEL <= 400
)
SELECT DT,
TO_CHAR(DT,'FMDay') DAY_NAME,
CEIL((DT - TRUNC(ADD_MONTHS(TRUNC(ADD_MONTHS(DT,-3),'YY'),3),'IW') + 1) / 7) WEEK_NUMBER
FROM T
/
10 /
DT DAY_NAME WEEK_NUMBER
---------- --------------- -----------
2016-04-01 Friday 1
2016-04-02 Saturday 1
2016-04-03 Sunday 1
2016-04-04 Monday 2
2016-04-05 Tuesday 2
2016-04-06 Wednesday 2
2016-04-07 Thursday 2
2016-04-08 Friday 2
2016-04-09 Saturday 2
2016-04-10 Sunday 2
2016-04-11 Monday 3
.
.
.
DT DAY_NAME WEEK_NUMBER
---------- --------------- -----------
2017-03-19 Sunday 51
2017-03-20 Monday 52
2017-03-21 Tuesday 52
2017-03-22 Wednesday 52
2017-03-23 Thursday 52
2017-03-24 Friday 52
2017-03-25 Saturday 52
2017-03-26 Sunday 52
2017-03-27 Monday 53
2017-03-28 Tuesday 53
2017-03-29 Wednesday 53
DT DAY_NAME WEEK_NUMBER
---------- --------------- -----------
2017-03-30 Thursday 53
2017-03-31 Friday 53
2017-04-01 Saturday 1
2017-04-02 Sunday 1
2017-04-03 Monday 2
2017-04-04 Tuesday 2
2017-04-05 Wednesday 2
2017-04-06 Thursday 2
2017-04-07 Friday 2
2017-04-08 Saturday 2
2017-04-09 Sunday 2
DT DAY_NAME WEEK_NUMBER
---------- --------------- -----------
2017-04-10 Monday 3
2017-04-11 Tuesday 3
2017-04-12 Wednesday 3
2017-04-13 Thursday 3
2017-04-14 Friday 3
2017-04-15 Saturday 3
2017-04-16 Sunday 3
2017-04-17 Monday 4
2017-04-18 Tuesday 4
2017-04-19 Wednesday 4
2017-04-20 Thursday 4
DT DAY_NAME WEEK_NUMBER
---------- --------------- -----------
2017-04-21 Friday 4
2017-04-22 Saturday 4
2017-04-23 Sunday 4
2017-04-24 Monday 5
2017-04-25 Tuesday 5
2017-04-26 Wednesday 5
2017-04-27 Thursday 5
2017-04-28 Friday 5
2017-04-29 Saturday 5
2017-04-30 Sunday 5
2017-05-01 Monday 6
DT DAY_NAME WEEK_NUMBER
---------- --------------- -----------
2017-05-02 Tuesday 6
2017-05-03 Wednesday 6
2017-05-04 Thursday 6
2017-05-05 Friday 6
400 rows selected.
SQL>
SY.
|
|
|
|
|
Re: getting finacial week number [message #612406 is a reply to message #612393] |
Thu, 17 April 2014 14:58 |
|
dariyoosh
Messages: 538 Registered: March 2009 Location: France
|
Senior Member |
|
|
Solomon Yakobson wrote on Thu, 17 April 2014 16:24Solution I posted assumes week 1 of fiscal year starts April 1. Your solution is totally wrong. The only reason it shows correct results for 2014 is April 1 is Tuesday. Look what happens for 2016:
. . .
Also, your query will continue week numbering if connect by spans multiple fiscal years while we need to reset week numer to 1
Thanks a lot for pointing out my error.
Testing it for other years, as you said, my solution is completely a mess !
Just to make sure that I understand your solution. When you write
. . .
trunc(add_months(trunc(add_months(t1.dateval, -3), 'yy'), 3), 'iw')
. . .
If I split it into parts what I understand is:
add_months(t1.dateval, -3)
Goes back 3 months for each date. Then
trunc(add_months(t1.dateval, -3), 'yy')
For example if the year is 2014 this gives: 2014-01-01 (and gives this value until 2015-03-31 where the fiscal year ends given the fact that in this question the end of the Gregorian year is not the same as the end of the fiscal year)
add_months(trunc(add_months(t1.dateval, -3), 'yy'), 3)
Again, for example if the year is 2014 this gives: the beginning date of the fiscal year: 2014-04-01 (and gives this value until 2015-03-31 where the fiscal year ends given the fact that in this question the end of the Gregorian year is not the same as the end of the fiscal year).
And finally
trunc(add_months(trunc(add_months(t1.dateval, -3), 'yy'), 3), 'iw')
Gives the date of the 1st Monday of the 1st week of the fiscal year (the week that starts according to ISO by Monday & includes the 1st of April, given the fact that trunc argument is provided with the format 'iw')
Is my understanding of this part of your solution correct?
Thanks,
|
|
|
Re: getting finacial week number [message #612407 is a reply to message #612406] |
Thu, 17 April 2014 15:26 |
Solomon Yakobson
Messages: 3275 Registered: January 2010 Location: Connecticut, USA
|
Senior Member |
|
|
trunc(add_months(trunc(add_months(t1.dateval, -3), 'yy'), 3), 'iw')
doesn't give "the date of the 1st Monday of the 1st week of the fiscal year". It gives last monday prior or equal to 1st day of fiscal year. This is point of reference. It makes sure only remainder of the week which started in prior fiscal year but ended in current fiscal year is marked as week 1.
SY.
|
|
|
|
|
|
Re: getting finacial week number [message #679822 is a reply to message #679813] |
Thu, 02 April 2020 10:43 |
Solomon Yakobson
Messages: 3275 Registered: January 2010 Location: Connecticut, USA
|
Senior Member |
|
|
set linesize 132
column dt format a22
column fiscal_year_start format a22
column fiscal_month_start format a22
column fiscal_week_start format a22
with data as (
select date '2019-03-31' + level dt
from dual
connect by date '2019-03-31' + level < date '2020-04-01'
)
select to_char(dt,'FM Day, mm/dd/yyyy') dt,
to_char(trunc(add_months(trunc(add_months(dt,-3),'yy'),3) + 1,'iw') - 1,'FM Day, mm/dd/yyyy') fiscal_year_start,
to_char(trunc(trunc(dt,'mm') + 1,'iw') - 1,'FM Day, mm/dd/yyyy') fiscal_month_start,
to_char(trunc(dt + 1,'iw') - 1,'FM Day, mm/dd/yyyy') fiscal_week_start,
(trunc(dt + 1,'iw') - trunc(add_months(trunc(add_months(dt,-3),'yy'),3) + 1,'iw')) / 7 + 1 week_number
from data
/
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Monday, 4/1/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 1
Tuesday, 4/2/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 1
Wednesday, 4/3/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 1
Thursday, 4/4/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 1
Friday, 4/5/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 1
Saturday, 4/6/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 1
Sunday, 4/7/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 Sunday, 4/7/2019 2
Monday, 4/8/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 Sunday, 4/7/2019 2
Tuesday, 4/9/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 Sunday, 4/7/2019 2
Wednesday, 4/10/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 Sunday, 4/7/2019 2
Thursday, 4/11/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 Sunday, 4/7/2019 2
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Friday, 4/12/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 Sunday, 4/7/2019 2
Saturday, 4/13/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 Sunday, 4/7/2019 2
Sunday, 4/14/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 Sunday, 4/14/2019 3
Monday, 4/15/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 Sunday, 4/14/2019 3
Tuesday, 4/16/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 Sunday, 4/14/2019 3
Wednesday, 4/17/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 Sunday, 4/14/2019 3
Thursday, 4/18/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 Sunday, 4/14/2019 3
Friday, 4/19/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 Sunday, 4/14/2019 3
Saturday, 4/20/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 Sunday, 4/14/2019 3
Sunday, 4/21/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 Sunday, 4/21/2019 4
Monday, 4/22/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 Sunday, 4/21/2019 4
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Tuesday, 4/23/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 Sunday, 4/21/2019 4
Wednesday, 4/24/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 Sunday, 4/21/2019 4
Thursday, 4/25/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 Sunday, 4/21/2019 4
Friday, 4/26/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 Sunday, 4/21/2019 4
Saturday, 4/27/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 Sunday, 4/21/2019 4
Sunday, 4/28/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 5
Monday, 4/29/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 5
Tuesday, 4/30/2019 Sunday, 3/31/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 5
Wednesday, 5/1/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 Sunday, 4/28/2019 5
Thursday, 5/2/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 Sunday, 4/28/2019 5
Friday, 5/3/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 Sunday, 4/28/2019 5
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Saturday, 5/4/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 Sunday, 4/28/2019 5
Sunday, 5/5/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 Sunday, 5/5/2019 6
Monday, 5/6/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 Sunday, 5/5/2019 6
Tuesday, 5/7/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 Sunday, 5/5/2019 6
Wednesday, 5/8/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 Sunday, 5/5/2019 6
Thursday, 5/9/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 Sunday, 5/5/2019 6
Friday, 5/10/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 Sunday, 5/5/2019 6
Saturday, 5/11/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 Sunday, 5/5/2019 6
Sunday, 5/12/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 Sunday, 5/12/2019 7
Monday, 5/13/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 Sunday, 5/12/2019 7
Tuesday, 5/14/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 Sunday, 5/12/2019 7
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Wednesday, 5/15/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 Sunday, 5/12/2019 7
Thursday, 5/16/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 Sunday, 5/12/2019 7
Friday, 5/17/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 Sunday, 5/12/2019 7
Saturday, 5/18/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 Sunday, 5/12/2019 7
Sunday, 5/19/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 Sunday, 5/19/2019 8
Monday, 5/20/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 Sunday, 5/19/2019 8
Tuesday, 5/21/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 Sunday, 5/19/2019 8
Wednesday, 5/22/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 Sunday, 5/19/2019 8
Thursday, 5/23/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 Sunday, 5/19/2019 8
Friday, 5/24/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 Sunday, 5/19/2019 8
Saturday, 5/25/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 Sunday, 5/19/2019 8
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Sunday, 5/26/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 Sunday, 5/26/2019 9
Monday, 5/27/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 Sunday, 5/26/2019 9
Tuesday, 5/28/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 Sunday, 5/26/2019 9
Wednesday, 5/29/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 Sunday, 5/26/2019 9
Thursday, 5/30/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 Sunday, 5/26/2019 9
Friday, 5/31/2019 Sunday, 3/31/2019 Sunday, 4/28/2019 Sunday, 5/26/2019 9
Saturday, 6/1/2019 Sunday, 3/31/2019 Sunday, 5/26/2019 Sunday, 5/26/2019 9
Sunday, 6/2/2019 Sunday, 3/31/2019 Sunday, 5/26/2019 Sunday, 6/2/2019 10
Monday, 6/3/2019 Sunday, 3/31/2019 Sunday, 5/26/2019 Sunday, 6/2/2019 10
Tuesday, 6/4/2019 Sunday, 3/31/2019 Sunday, 5/26/2019 Sunday, 6/2/2019 10
Wednesday, 6/5/2019 Sunday, 3/31/2019 Sunday, 5/26/2019 Sunday, 6/2/2019 10
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Thursday, 6/6/2019 Sunday, 3/31/2019 Sunday, 5/26/2019 Sunday, 6/2/2019 10
Friday, 6/7/2019 Sunday, 3/31/2019 Sunday, 5/26/2019 Sunday, 6/2/2019 10
Saturday, 6/8/2019 Sunday, 3/31/2019 Sunday, 5/26/2019 Sunday, 6/2/2019 10
Sunday, 6/9/2019 Sunday, 3/31/2019 Sunday, 5/26/2019 Sunday, 6/9/2019 11
Monday, 6/10/2019 Sunday, 3/31/2019 Sunday, 5/26/2019 Sunday, 6/9/2019 11
Tuesday, 6/11/2019 Sunday, 3/31/2019 Sunday, 5/26/2019 Sunday, 6/9/2019 11
Wednesday, 6/12/2019 Sunday, 3/31/2019 Sunday, 5/26/2019 Sunday, 6/9/2019 11
Thursday, 6/13/2019 Sunday, 3/31/2019 Sunday, 5/26/2019 Sunday, 6/9/2019 11
Friday, 6/14/2019 Sunday, 3/31/2019 Sunday, 5/26/2019 Sunday, 6/9/2019 11
Saturday, 6/15/2019 Sunday, 3/31/2019 Sunday, 5/26/2019 Sunday, 6/9/2019 11
Sunday, 6/16/2019 Sunday, 3/31/2019 Sunday, 5/26/2019 Sunday, 6/16/2019 12
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Monday, 6/17/2019 Sunday, 3/31/2019 Sunday, 5/26/2019 Sunday, 6/16/2019 12
Tuesday, 6/18/2019 Sunday, 3/31/2019 Sunday, 5/26/2019 Sunday, 6/16/2019 12
Wednesday, 6/19/2019 Sunday, 3/31/2019 Sunday, 5/26/2019 Sunday, 6/16/2019 12
Thursday, 6/20/2019 Sunday, 3/31/2019 Sunday, 5/26/2019 Sunday, 6/16/2019 12
Friday, 6/21/2019 Sunday, 3/31/2019 Sunday, 5/26/2019 Sunday, 6/16/2019 12
Saturday, 6/22/2019 Sunday, 3/31/2019 Sunday, 5/26/2019 Sunday, 6/16/2019 12
Sunday, 6/23/2019 Sunday, 3/31/2019 Sunday, 5/26/2019 Sunday, 6/23/2019 13
Monday, 6/24/2019 Sunday, 3/31/2019 Sunday, 5/26/2019 Sunday, 6/23/2019 13
Tuesday, 6/25/2019 Sunday, 3/31/2019 Sunday, 5/26/2019 Sunday, 6/23/2019 13
Wednesday, 6/26/2019 Sunday, 3/31/2019 Sunday, 5/26/2019 Sunday, 6/23/2019 13
Thursday, 6/27/2019 Sunday, 3/31/2019 Sunday, 5/26/2019 Sunday, 6/23/2019 13
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Friday, 6/28/2019 Sunday, 3/31/2019 Sunday, 5/26/2019 Sunday, 6/23/2019 13
Saturday, 6/29/2019 Sunday, 3/31/2019 Sunday, 5/26/2019 Sunday, 6/23/2019 13
Sunday, 6/30/2019 Sunday, 3/31/2019 Sunday, 5/26/2019 Sunday, 6/30/2019 14
Monday, 7/1/2019 Sunday, 3/31/2019 Sunday, 6/30/2019 Sunday, 6/30/2019 14
Tuesday, 7/2/2019 Sunday, 3/31/2019 Sunday, 6/30/2019 Sunday, 6/30/2019 14
Wednesday, 7/3/2019 Sunday, 3/31/2019 Sunday, 6/30/2019 Sunday, 6/30/2019 14
Thursday, 7/4/2019 Sunday, 3/31/2019 Sunday, 6/30/2019 Sunday, 6/30/2019 14
Friday, 7/5/2019 Sunday, 3/31/2019 Sunday, 6/30/2019 Sunday, 6/30/2019 14
Saturday, 7/6/2019 Sunday, 3/31/2019 Sunday, 6/30/2019 Sunday, 6/30/2019 14
Sunday, 7/7/2019 Sunday, 3/31/2019 Sunday, 6/30/2019 Sunday, 7/7/2019 15
Monday, 7/8/2019 Sunday, 3/31/2019 Sunday, 6/30/2019 Sunday, 7/7/2019 15
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Tuesday, 7/9/2019 Sunday, 3/31/2019 Sunday, 6/30/2019 Sunday, 7/7/2019 15
Wednesday, 7/10/2019 Sunday, 3/31/2019 Sunday, 6/30/2019 Sunday, 7/7/2019 15
Thursday, 7/11/2019 Sunday, 3/31/2019 Sunday, 6/30/2019 Sunday, 7/7/2019 15
Friday, 7/12/2019 Sunday, 3/31/2019 Sunday, 6/30/2019 Sunday, 7/7/2019 15
Saturday, 7/13/2019 Sunday, 3/31/2019 Sunday, 6/30/2019 Sunday, 7/7/2019 15
Sunday, 7/14/2019 Sunday, 3/31/2019 Sunday, 6/30/2019 Sunday, 7/14/2019 16
Monday, 7/15/2019 Sunday, 3/31/2019 Sunday, 6/30/2019 Sunday, 7/14/2019 16
Tuesday, 7/16/2019 Sunday, 3/31/2019 Sunday, 6/30/2019 Sunday, 7/14/2019 16
Wednesday, 7/17/2019 Sunday, 3/31/2019 Sunday, 6/30/2019 Sunday, 7/14/2019 16
Thursday, 7/18/2019 Sunday, 3/31/2019 Sunday, 6/30/2019 Sunday, 7/14/2019 16
Friday, 7/19/2019 Sunday, 3/31/2019 Sunday, 6/30/2019 Sunday, 7/14/2019 16
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Saturday, 7/20/2019 Sunday, 3/31/2019 Sunday, 6/30/2019 Sunday, 7/14/2019 16
Sunday, 7/21/2019 Sunday, 3/31/2019 Sunday, 6/30/2019 Sunday, 7/21/2019 17
Monday, 7/22/2019 Sunday, 3/31/2019 Sunday, 6/30/2019 Sunday, 7/21/2019 17
Tuesday, 7/23/2019 Sunday, 3/31/2019 Sunday, 6/30/2019 Sunday, 7/21/2019 17
Wednesday, 7/24/2019 Sunday, 3/31/2019 Sunday, 6/30/2019 Sunday, 7/21/2019 17
Thursday, 7/25/2019 Sunday, 3/31/2019 Sunday, 6/30/2019 Sunday, 7/21/2019 17
Friday, 7/26/2019 Sunday, 3/31/2019 Sunday, 6/30/2019 Sunday, 7/21/2019 17
Saturday, 7/27/2019 Sunday, 3/31/2019 Sunday, 6/30/2019 Sunday, 7/21/2019 17
Sunday, 7/28/2019 Sunday, 3/31/2019 Sunday, 6/30/2019 Sunday, 7/28/2019 18
Monday, 7/29/2019 Sunday, 3/31/2019 Sunday, 6/30/2019 Sunday, 7/28/2019 18
Tuesday, 7/30/2019 Sunday, 3/31/2019 Sunday, 6/30/2019 Sunday, 7/28/2019 18
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Wednesday, 7/31/2019 Sunday, 3/31/2019 Sunday, 6/30/2019 Sunday, 7/28/2019 18
Thursday, 8/1/2019 Sunday, 3/31/2019 Sunday, 7/28/2019 Sunday, 7/28/2019 18
Friday, 8/2/2019 Sunday, 3/31/2019 Sunday, 7/28/2019 Sunday, 7/28/2019 18
Saturday, 8/3/2019 Sunday, 3/31/2019 Sunday, 7/28/2019 Sunday, 7/28/2019 18
Sunday, 8/4/2019 Sunday, 3/31/2019 Sunday, 7/28/2019 Sunday, 8/4/2019 19
Monday, 8/5/2019 Sunday, 3/31/2019 Sunday, 7/28/2019 Sunday, 8/4/2019 19
Tuesday, 8/6/2019 Sunday, 3/31/2019 Sunday, 7/28/2019 Sunday, 8/4/2019 19
Wednesday, 8/7/2019 Sunday, 3/31/2019 Sunday, 7/28/2019 Sunday, 8/4/2019 19
Thursday, 8/8/2019 Sunday, 3/31/2019 Sunday, 7/28/2019 Sunday, 8/4/2019 19
Friday, 8/9/2019 Sunday, 3/31/2019 Sunday, 7/28/2019 Sunday, 8/4/2019 19
Saturday, 8/10/2019 Sunday, 3/31/2019 Sunday, 7/28/2019 Sunday, 8/4/2019 19
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Sunday, 8/11/2019 Sunday, 3/31/2019 Sunday, 7/28/2019 Sunday, 8/11/2019 20
Monday, 8/12/2019 Sunday, 3/31/2019 Sunday, 7/28/2019 Sunday, 8/11/2019 20
Tuesday, 8/13/2019 Sunday, 3/31/2019 Sunday, 7/28/2019 Sunday, 8/11/2019 20
Wednesday, 8/14/2019 Sunday, 3/31/2019 Sunday, 7/28/2019 Sunday, 8/11/2019 20
Thursday, 8/15/2019 Sunday, 3/31/2019 Sunday, 7/28/2019 Sunday, 8/11/2019 20
Friday, 8/16/2019 Sunday, 3/31/2019 Sunday, 7/28/2019 Sunday, 8/11/2019 20
Saturday, 8/17/2019 Sunday, 3/31/2019 Sunday, 7/28/2019 Sunday, 8/11/2019 20
Sunday, 8/18/2019 Sunday, 3/31/2019 Sunday, 7/28/2019 Sunday, 8/18/2019 21
Monday, 8/19/2019 Sunday, 3/31/2019 Sunday, 7/28/2019 Sunday, 8/18/2019 21
Tuesday, 8/20/2019 Sunday, 3/31/2019 Sunday, 7/28/2019 Sunday, 8/18/2019 21
Wednesday, 8/21/2019 Sunday, 3/31/2019 Sunday, 7/28/2019 Sunday, 8/18/2019 21
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Thursday, 8/22/2019 Sunday, 3/31/2019 Sunday, 7/28/2019 Sunday, 8/18/2019 21
Friday, 8/23/2019 Sunday, 3/31/2019 Sunday, 7/28/2019 Sunday, 8/18/2019 21
Saturday, 8/24/2019 Sunday, 3/31/2019 Sunday, 7/28/2019 Sunday, 8/18/2019 21
Sunday, 8/25/2019 Sunday, 3/31/2019 Sunday, 7/28/2019 Sunday, 8/25/2019 22
Monday, 8/26/2019 Sunday, 3/31/2019 Sunday, 7/28/2019 Sunday, 8/25/2019 22
Tuesday, 8/27/2019 Sunday, 3/31/2019 Sunday, 7/28/2019 Sunday, 8/25/2019 22
Wednesday, 8/28/2019 Sunday, 3/31/2019 Sunday, 7/28/2019 Sunday, 8/25/2019 22
Thursday, 8/29/2019 Sunday, 3/31/2019 Sunday, 7/28/2019 Sunday, 8/25/2019 22
Friday, 8/30/2019 Sunday, 3/31/2019 Sunday, 7/28/2019 Sunday, 8/25/2019 22
Saturday, 8/31/2019 Sunday, 3/31/2019 Sunday, 7/28/2019 Sunday, 8/25/2019 22
Sunday, 9/1/2019 Sunday, 3/31/2019 Sunday, 9/1/2019 Sunday, 9/1/2019 23
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Monday, 9/2/2019 Sunday, 3/31/2019 Sunday, 9/1/2019 Sunday, 9/1/2019 23
Tuesday, 9/3/2019 Sunday, 3/31/2019 Sunday, 9/1/2019 Sunday, 9/1/2019 23
Wednesday, 9/4/2019 Sunday, 3/31/2019 Sunday, 9/1/2019 Sunday, 9/1/2019 23
Thursday, 9/5/2019 Sunday, 3/31/2019 Sunday, 9/1/2019 Sunday, 9/1/2019 23
Friday, 9/6/2019 Sunday, 3/31/2019 Sunday, 9/1/2019 Sunday, 9/1/2019 23
Saturday, 9/7/2019 Sunday, 3/31/2019 Sunday, 9/1/2019 Sunday, 9/1/2019 23
Sunday, 9/8/2019 Sunday, 3/31/2019 Sunday, 9/1/2019 Sunday, 9/8/2019 24
Monday, 9/9/2019 Sunday, 3/31/2019 Sunday, 9/1/2019 Sunday, 9/8/2019 24
Tuesday, 9/10/2019 Sunday, 3/31/2019 Sunday, 9/1/2019 Sunday, 9/8/2019 24
Wednesday, 9/11/2019 Sunday, 3/31/2019 Sunday, 9/1/2019 Sunday, 9/8/2019 24
Thursday, 9/12/2019 Sunday, 3/31/2019 Sunday, 9/1/2019 Sunday, 9/8/2019 24
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Friday, 9/13/2019 Sunday, 3/31/2019 Sunday, 9/1/2019 Sunday, 9/8/2019 24
Saturday, 9/14/2019 Sunday, 3/31/2019 Sunday, 9/1/2019 Sunday, 9/8/2019 24
Sunday, 9/15/2019 Sunday, 3/31/2019 Sunday, 9/1/2019 Sunday, 9/15/2019 25
Monday, 9/16/2019 Sunday, 3/31/2019 Sunday, 9/1/2019 Sunday, 9/15/2019 25
Tuesday, 9/17/2019 Sunday, 3/31/2019 Sunday, 9/1/2019 Sunday, 9/15/2019 25
Wednesday, 9/18/2019 Sunday, 3/31/2019 Sunday, 9/1/2019 Sunday, 9/15/2019 25
Thursday, 9/19/2019 Sunday, 3/31/2019 Sunday, 9/1/2019 Sunday, 9/15/2019 25
Friday, 9/20/2019 Sunday, 3/31/2019 Sunday, 9/1/2019 Sunday, 9/15/2019 25
Saturday, 9/21/2019 Sunday, 3/31/2019 Sunday, 9/1/2019 Sunday, 9/15/2019 25
Sunday, 9/22/2019 Sunday, 3/31/2019 Sunday, 9/1/2019 Sunday, 9/22/2019 26
Monday, 9/23/2019 Sunday, 3/31/2019 Sunday, 9/1/2019 Sunday, 9/22/2019 26
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Tuesday, 9/24/2019 Sunday, 3/31/2019 Sunday, 9/1/2019 Sunday, 9/22/2019 26
Wednesday, 9/25/2019 Sunday, 3/31/2019 Sunday, 9/1/2019 Sunday, 9/22/2019 26
Thursday, 9/26/2019 Sunday, 3/31/2019 Sunday, 9/1/2019 Sunday, 9/22/2019 26
Friday, 9/27/2019 Sunday, 3/31/2019 Sunday, 9/1/2019 Sunday, 9/22/2019 26
Saturday, 9/28/2019 Sunday, 3/31/2019 Sunday, 9/1/2019 Sunday, 9/22/2019 26
Sunday, 9/29/2019 Sunday, 3/31/2019 Sunday, 9/1/2019 Sunday, 9/29/2019 27
Monday, 9/30/2019 Sunday, 3/31/2019 Sunday, 9/1/2019 Sunday, 9/29/2019 27
Tuesday, 10/1/2019 Sunday, 3/31/2019 Sunday, 9/29/2019 Sunday, 9/29/2019 27
Wednesday, 10/2/2019 Sunday, 3/31/2019 Sunday, 9/29/2019 Sunday, 9/29/2019 27
Thursday, 10/3/2019 Sunday, 3/31/2019 Sunday, 9/29/2019 Sunday, 9/29/2019 27
Friday, 10/4/2019 Sunday, 3/31/2019 Sunday, 9/29/2019 Sunday, 9/29/2019 27
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Saturday, 10/5/2019 Sunday, 3/31/2019 Sunday, 9/29/2019 Sunday, 9/29/2019 27
Sunday, 10/6/2019 Sunday, 3/31/2019 Sunday, 9/29/2019 Sunday, 10/6/2019 28
Monday, 10/7/2019 Sunday, 3/31/2019 Sunday, 9/29/2019 Sunday, 10/6/2019 28
Tuesday, 10/8/2019 Sunday, 3/31/2019 Sunday, 9/29/2019 Sunday, 10/6/2019 28
Wednesday, 10/9/2019 Sunday, 3/31/2019 Sunday, 9/29/2019 Sunday, 10/6/2019 28
Thursday, 10/10/2019 Sunday, 3/31/2019 Sunday, 9/29/2019 Sunday, 10/6/2019 28
Friday, 10/11/2019 Sunday, 3/31/2019 Sunday, 9/29/2019 Sunday, 10/6/2019 28
Saturday, 10/12/2019 Sunday, 3/31/2019 Sunday, 9/29/2019 Sunday, 10/6/2019 28
Sunday, 10/13/2019 Sunday, 3/31/2019 Sunday, 9/29/2019 Sunday, 10/13/2019 29
Monday, 10/14/2019 Sunday, 3/31/2019 Sunday, 9/29/2019 Sunday, 10/13/2019 29
Tuesday, 10/15/2019 Sunday, 3/31/2019 Sunday, 9/29/2019 Sunday, 10/13/2019 29
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Wednesday, 10/16/2019 Sunday, 3/31/2019 Sunday, 9/29/2019 Sunday, 10/13/2019 29
Thursday, 10/17/2019 Sunday, 3/31/2019 Sunday, 9/29/2019 Sunday, 10/13/2019 29
Friday, 10/18/2019 Sunday, 3/31/2019 Sunday, 9/29/2019 Sunday, 10/13/2019 29
Saturday, 10/19/2019 Sunday, 3/31/2019 Sunday, 9/29/2019 Sunday, 10/13/2019 29
Sunday, 10/20/2019 Sunday, 3/31/2019 Sunday, 9/29/2019 Sunday, 10/20/2019 30
Monday, 10/21/2019 Sunday, 3/31/2019 Sunday, 9/29/2019 Sunday, 10/20/2019 30
Tuesday, 10/22/2019 Sunday, 3/31/2019 Sunday, 9/29/2019 Sunday, 10/20/2019 30
Wednesday, 10/23/2019 Sunday, 3/31/2019 Sunday, 9/29/2019 Sunday, 10/20/2019 30
Thursday, 10/24/2019 Sunday, 3/31/2019 Sunday, 9/29/2019 Sunday, 10/20/2019 30
Friday, 10/25/2019 Sunday, 3/31/2019 Sunday, 9/29/2019 Sunday, 10/20/2019 30
Saturday, 10/26/2019 Sunday, 3/31/2019 Sunday, 9/29/2019 Sunday, 10/20/2019 30
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Sunday, 10/27/2019 Sunday, 3/31/2019 Sunday, 9/29/2019 Sunday, 10/27/2019 31
Monday, 10/28/2019 Sunday, 3/31/2019 Sunday, 9/29/2019 Sunday, 10/27/2019 31
Tuesday, 10/29/2019 Sunday, 3/31/2019 Sunday, 9/29/2019 Sunday, 10/27/2019 31
Wednesday, 10/30/2019 Sunday, 3/31/2019 Sunday, 9/29/2019 Sunday, 10/27/2019 31
Thursday, 10/31/2019 Sunday, 3/31/2019 Sunday, 9/29/2019 Sunday, 10/27/2019 31
Friday, 11/1/2019 Sunday, 3/31/2019 Sunday, 10/27/2019 Sunday, 10/27/2019 31
Saturday, 11/2/2019 Sunday, 3/31/2019 Sunday, 10/27/2019 Sunday, 10/27/2019 31
Sunday, 11/3/2019 Sunday, 3/31/2019 Sunday, 10/27/2019 Sunday, 11/3/2019 32
Monday, 11/4/2019 Sunday, 3/31/2019 Sunday, 10/27/2019 Sunday, 11/3/2019 32
Tuesday, 11/5/2019 Sunday, 3/31/2019 Sunday, 10/27/2019 Sunday, 11/3/2019 32
Wednesday, 11/6/2019 Sunday, 3/31/2019 Sunday, 10/27/2019 Sunday, 11/3/2019 32
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Thursday, 11/7/2019 Sunday, 3/31/2019 Sunday, 10/27/2019 Sunday, 11/3/2019 32
Friday, 11/8/2019 Sunday, 3/31/2019 Sunday, 10/27/2019 Sunday, 11/3/2019 32
Saturday, 11/9/2019 Sunday, 3/31/2019 Sunday, 10/27/2019 Sunday, 11/3/2019 32
Sunday, 11/10/2019 Sunday, 3/31/2019 Sunday, 10/27/2019 Sunday, 11/10/2019 33
Monday, 11/11/2019 Sunday, 3/31/2019 Sunday, 10/27/2019 Sunday, 11/10/2019 33
Tuesday, 11/12/2019 Sunday, 3/31/2019 Sunday, 10/27/2019 Sunday, 11/10/2019 33
Wednesday, 11/13/2019 Sunday, 3/31/2019 Sunday, 10/27/2019 Sunday, 11/10/2019 33
Thursday, 11/14/2019 Sunday, 3/31/2019 Sunday, 10/27/2019 Sunday, 11/10/2019 33
Friday, 11/15/2019 Sunday, 3/31/2019 Sunday, 10/27/2019 Sunday, 11/10/2019 33
Saturday, 11/16/2019 Sunday, 3/31/2019 Sunday, 10/27/2019 Sunday, 11/10/2019 33
Sunday, 11/17/2019 Sunday, 3/31/2019 Sunday, 10/27/2019 Sunday, 11/17/2019 34
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Monday, 11/18/2019 Sunday, 3/31/2019 Sunday, 10/27/2019 Sunday, 11/17/2019 34
Tuesday, 11/19/2019 Sunday, 3/31/2019 Sunday, 10/27/2019 Sunday, 11/17/2019 34
Wednesday, 11/20/2019 Sunday, 3/31/2019 Sunday, 10/27/2019 Sunday, 11/17/2019 34
Thursday, 11/21/2019 Sunday, 3/31/2019 Sunday, 10/27/2019 Sunday, 11/17/2019 34
Friday, 11/22/2019 Sunday, 3/31/2019 Sunday, 10/27/2019 Sunday, 11/17/2019 34
Saturday, 11/23/2019 Sunday, 3/31/2019 Sunday, 10/27/2019 Sunday, 11/17/2019 34
Sunday, 11/24/2019 Sunday, 3/31/2019 Sunday, 10/27/2019 Sunday, 11/24/2019 35
Monday, 11/25/2019 Sunday, 3/31/2019 Sunday, 10/27/2019 Sunday, 11/24/2019 35
Tuesday, 11/26/2019 Sunday, 3/31/2019 Sunday, 10/27/2019 Sunday, 11/24/2019 35
Wednesday, 11/27/2019 Sunday, 3/31/2019 Sunday, 10/27/2019 Sunday, 11/24/2019 35
Thursday, 11/28/2019 Sunday, 3/31/2019 Sunday, 10/27/2019 Sunday, 11/24/2019 35
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Friday, 11/29/2019 Sunday, 3/31/2019 Sunday, 10/27/2019 Sunday, 11/24/2019 35
Saturday, 11/30/2019 Sunday, 3/31/2019 Sunday, 10/27/2019 Sunday, 11/24/2019 35
Sunday, 12/1/2019 Sunday, 3/31/2019 Sunday, 12/1/2019 Sunday, 12/1/2019 36
Monday, 12/2/2019 Sunday, 3/31/2019 Sunday, 12/1/2019 Sunday, 12/1/2019 36
Tuesday, 12/3/2019 Sunday, 3/31/2019 Sunday, 12/1/2019 Sunday, 12/1/2019 36
Wednesday, 12/4/2019 Sunday, 3/31/2019 Sunday, 12/1/2019 Sunday, 12/1/2019 36
Thursday, 12/5/2019 Sunday, 3/31/2019 Sunday, 12/1/2019 Sunday, 12/1/2019 36
Friday, 12/6/2019 Sunday, 3/31/2019 Sunday, 12/1/2019 Sunday, 12/1/2019 36
Saturday, 12/7/2019 Sunday, 3/31/2019 Sunday, 12/1/2019 Sunday, 12/1/2019 36
Sunday, 12/8/2019 Sunday, 3/31/2019 Sunday, 12/1/2019 Sunday, 12/8/2019 37
Monday, 12/9/2019 Sunday, 3/31/2019 Sunday, 12/1/2019 Sunday, 12/8/2019 37
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Tuesday, 12/10/2019 Sunday, 3/31/2019 Sunday, 12/1/2019 Sunday, 12/8/2019 37
Wednesday, 12/11/2019 Sunday, 3/31/2019 Sunday, 12/1/2019 Sunday, 12/8/2019 37
Thursday, 12/12/2019 Sunday, 3/31/2019 Sunday, 12/1/2019 Sunday, 12/8/2019 37
Friday, 12/13/2019 Sunday, 3/31/2019 Sunday, 12/1/2019 Sunday, 12/8/2019 37
Saturday, 12/14/2019 Sunday, 3/31/2019 Sunday, 12/1/2019 Sunday, 12/8/2019 37
Sunday, 12/15/2019 Sunday, 3/31/2019 Sunday, 12/1/2019 Sunday, 12/15/2019 38
Monday, 12/16/2019 Sunday, 3/31/2019 Sunday, 12/1/2019 Sunday, 12/15/2019 38
Tuesday, 12/17/2019 Sunday, 3/31/2019 Sunday, 12/1/2019 Sunday, 12/15/2019 38
Wednesday, 12/18/2019 Sunday, 3/31/2019 Sunday, 12/1/2019 Sunday, 12/15/2019 38
Thursday, 12/19/2019 Sunday, 3/31/2019 Sunday, 12/1/2019 Sunday, 12/15/2019 38
Friday, 12/20/2019 Sunday, 3/31/2019 Sunday, 12/1/2019 Sunday, 12/15/2019 38
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Saturday, 12/21/2019 Sunday, 3/31/2019 Sunday, 12/1/2019 Sunday, 12/15/2019 38
Sunday, 12/22/2019 Sunday, 3/31/2019 Sunday, 12/1/2019 Sunday, 12/22/2019 39
Monday, 12/23/2019 Sunday, 3/31/2019 Sunday, 12/1/2019 Sunday, 12/22/2019 39
Tuesday, 12/24/2019 Sunday, 3/31/2019 Sunday, 12/1/2019 Sunday, 12/22/2019 39
Wednesday, 12/25/2019 Sunday, 3/31/2019 Sunday, 12/1/2019 Sunday, 12/22/2019 39
Thursday, 12/26/2019 Sunday, 3/31/2019 Sunday, 12/1/2019 Sunday, 12/22/2019 39
Friday, 12/27/2019 Sunday, 3/31/2019 Sunday, 12/1/2019 Sunday, 12/22/2019 39
Saturday, 12/28/2019 Sunday, 3/31/2019 Sunday, 12/1/2019 Sunday, 12/22/2019 39
Sunday, 12/29/2019 Sunday, 3/31/2019 Sunday, 12/1/2019 Sunday, 12/29/2019 40
Monday, 12/30/2019 Sunday, 3/31/2019 Sunday, 12/1/2019 Sunday, 12/29/2019 40
Tuesday, 12/31/2019 Sunday, 3/31/2019 Sunday, 12/1/2019 Sunday, 12/29/2019 40
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Wednesday, 1/1/2020 Sunday, 3/31/2019 Sunday, 12/29/2019 Sunday, 12/29/2019 40
Thursday, 1/2/2020 Sunday, 3/31/2019 Sunday, 12/29/2019 Sunday, 12/29/2019 40
Friday, 1/3/2020 Sunday, 3/31/2019 Sunday, 12/29/2019 Sunday, 12/29/2019 40
Saturday, 1/4/2020 Sunday, 3/31/2019 Sunday, 12/29/2019 Sunday, 12/29/2019 40
Sunday, 1/5/2020 Sunday, 3/31/2019 Sunday, 12/29/2019 Sunday, 1/5/2020 41
Monday, 1/6/2020 Sunday, 3/31/2019 Sunday, 12/29/2019 Sunday, 1/5/2020 41
Tuesday, 1/7/2020 Sunday, 3/31/2019 Sunday, 12/29/2019 Sunday, 1/5/2020 41
Wednesday, 1/8/2020 Sunday, 3/31/2019 Sunday, 12/29/2019 Sunday, 1/5/2020 41
Thursday, 1/9/2020 Sunday, 3/31/2019 Sunday, 12/29/2019 Sunday, 1/5/2020 41
Friday, 1/10/2020 Sunday, 3/31/2019 Sunday, 12/29/2019 Sunday, 1/5/2020 41
Saturday, 1/11/2020 Sunday, 3/31/2019 Sunday, 12/29/2019 Sunday, 1/5/2020 41
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Sunday, 1/12/2020 Sunday, 3/31/2019 Sunday, 12/29/2019 Sunday, 1/12/2020 42
Monday, 1/13/2020 Sunday, 3/31/2019 Sunday, 12/29/2019 Sunday, 1/12/2020 42
Tuesday, 1/14/2020 Sunday, 3/31/2019 Sunday, 12/29/2019 Sunday, 1/12/2020 42
Wednesday, 1/15/2020 Sunday, 3/31/2019 Sunday, 12/29/2019 Sunday, 1/12/2020 42
Thursday, 1/16/2020 Sunday, 3/31/2019 Sunday, 12/29/2019 Sunday, 1/12/2020 42
Friday, 1/17/2020 Sunday, 3/31/2019 Sunday, 12/29/2019 Sunday, 1/12/2020 42
Saturday, 1/18/2020 Sunday, 3/31/2019 Sunday, 12/29/2019 Sunday, 1/12/2020 42
Sunday, 1/19/2020 Sunday, 3/31/2019 Sunday, 12/29/2019 Sunday, 1/19/2020 43
Monday, 1/20/2020 Sunday, 3/31/2019 Sunday, 12/29/2019 Sunday, 1/19/2020 43
Tuesday, 1/21/2020 Sunday, 3/31/2019 Sunday, 12/29/2019 Sunday, 1/19/2020 43
Wednesday, 1/22/2020 Sunday, 3/31/2019 Sunday, 12/29/2019 Sunday, 1/19/2020 43
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Thursday, 1/23/2020 Sunday, 3/31/2019 Sunday, 12/29/2019 Sunday, 1/19/2020 43
Friday, 1/24/2020 Sunday, 3/31/2019 Sunday, 12/29/2019 Sunday, 1/19/2020 43
Saturday, 1/25/2020 Sunday, 3/31/2019 Sunday, 12/29/2019 Sunday, 1/19/2020 43
Sunday, 1/26/2020 Sunday, 3/31/2019 Sunday, 12/29/2019 Sunday, 1/26/2020 44
Monday, 1/27/2020 Sunday, 3/31/2019 Sunday, 12/29/2019 Sunday, 1/26/2020 44
Tuesday, 1/28/2020 Sunday, 3/31/2019 Sunday, 12/29/2019 Sunday, 1/26/2020 44
Wednesday, 1/29/2020 Sunday, 3/31/2019 Sunday, 12/29/2019 Sunday, 1/26/2020 44
Thursday, 1/30/2020 Sunday, 3/31/2019 Sunday, 12/29/2019 Sunday, 1/26/2020 44
Friday, 1/31/2020 Sunday, 3/31/2019 Sunday, 12/29/2019 Sunday, 1/26/2020 44
Saturday, 2/1/2020 Sunday, 3/31/2019 Sunday, 1/26/2020 Sunday, 1/26/2020 44
Sunday, 2/2/2020 Sunday, 3/31/2019 Sunday, 1/26/2020 Sunday, 2/2/2020 45
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Monday, 2/3/2020 Sunday, 3/31/2019 Sunday, 1/26/2020 Sunday, 2/2/2020 45
Tuesday, 2/4/2020 Sunday, 3/31/2019 Sunday, 1/26/2020 Sunday, 2/2/2020 45
Wednesday, 2/5/2020 Sunday, 3/31/2019 Sunday, 1/26/2020 Sunday, 2/2/2020 45
Thursday, 2/6/2020 Sunday, 3/31/2019 Sunday, 1/26/2020 Sunday, 2/2/2020 45
Friday, 2/7/2020 Sunday, 3/31/2019 Sunday, 1/26/2020 Sunday, 2/2/2020 45
Saturday, 2/8/2020 Sunday, 3/31/2019 Sunday, 1/26/2020 Sunday, 2/2/2020 45
Sunday, 2/9/2020 Sunday, 3/31/2019 Sunday, 1/26/2020 Sunday, 2/9/2020 46
Monday, 2/10/2020 Sunday, 3/31/2019 Sunday, 1/26/2020 Sunday, 2/9/2020 46
Tuesday, 2/11/2020 Sunday, 3/31/2019 Sunday, 1/26/2020 Sunday, 2/9/2020 46
Wednesday, 2/12/2020 Sunday, 3/31/2019 Sunday, 1/26/2020 Sunday, 2/9/2020 46
Thursday, 2/13/2020 Sunday, 3/31/2019 Sunday, 1/26/2020 Sunday, 2/9/2020 46
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Friday, 2/14/2020 Sunday, 3/31/2019 Sunday, 1/26/2020 Sunday, 2/9/2020 46
Saturday, 2/15/2020 Sunday, 3/31/2019 Sunday, 1/26/2020 Sunday, 2/9/2020 46
Sunday, 2/16/2020 Sunday, 3/31/2019 Sunday, 1/26/2020 Sunday, 2/16/2020 47
Monday, 2/17/2020 Sunday, 3/31/2019 Sunday, 1/26/2020 Sunday, 2/16/2020 47
Tuesday, 2/18/2020 Sunday, 3/31/2019 Sunday, 1/26/2020 Sunday, 2/16/2020 47
Wednesday, 2/19/2020 Sunday, 3/31/2019 Sunday, 1/26/2020 Sunday, 2/16/2020 47
Thursday, 2/20/2020 Sunday, 3/31/2019 Sunday, 1/26/2020 Sunday, 2/16/2020 47
Friday, 2/21/2020 Sunday, 3/31/2019 Sunday, 1/26/2020 Sunday, 2/16/2020 47
Saturday, 2/22/2020 Sunday, 3/31/2019 Sunday, 1/26/2020 Sunday, 2/16/2020 47
Sunday, 2/23/2020 Sunday, 3/31/2019 Sunday, 1/26/2020 Sunday, 2/23/2020 48
Monday, 2/24/2020 Sunday, 3/31/2019 Sunday, 1/26/2020 Sunday, 2/23/2020 48
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Tuesday, 2/25/2020 Sunday, 3/31/2019 Sunday, 1/26/2020 Sunday, 2/23/2020 48
Wednesday, 2/26/2020 Sunday, 3/31/2019 Sunday, 1/26/2020 Sunday, 2/23/2020 48
Thursday, 2/27/2020 Sunday, 3/31/2019 Sunday, 1/26/2020 Sunday, 2/23/2020 48
Friday, 2/28/2020 Sunday, 3/31/2019 Sunday, 1/26/2020 Sunday, 2/23/2020 48
Saturday, 2/29/2020 Sunday, 3/31/2019 Sunday, 1/26/2020 Sunday, 2/23/2020 48
Sunday, 3/1/2020 Sunday, 3/31/2019 Sunday, 3/1/2020 Sunday, 3/1/2020 49
Monday, 3/2/2020 Sunday, 3/31/2019 Sunday, 3/1/2020 Sunday, 3/1/2020 49
Tuesday, 3/3/2020 Sunday, 3/31/2019 Sunday, 3/1/2020 Sunday, 3/1/2020 49
Wednesday, 3/4/2020 Sunday, 3/31/2019 Sunday, 3/1/2020 Sunday, 3/1/2020 49
Thursday, 3/5/2020 Sunday, 3/31/2019 Sunday, 3/1/2020 Sunday, 3/1/2020 49
Friday, 3/6/2020 Sunday, 3/31/2019 Sunday, 3/1/2020 Sunday, 3/1/2020 49
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Saturday, 3/7/2020 Sunday, 3/31/2019 Sunday, 3/1/2020 Sunday, 3/1/2020 49
Sunday, 3/8/2020 Sunday, 3/31/2019 Sunday, 3/1/2020 Sunday, 3/8/2020 50
Monday, 3/9/2020 Sunday, 3/31/2019 Sunday, 3/1/2020 Sunday, 3/8/2020 50
Tuesday, 3/10/2020 Sunday, 3/31/2019 Sunday, 3/1/2020 Sunday, 3/8/2020 50
Wednesday, 3/11/2020 Sunday, 3/31/2019 Sunday, 3/1/2020 Sunday, 3/8/2020 50
Thursday, 3/12/2020 Sunday, 3/31/2019 Sunday, 3/1/2020 Sunday, 3/8/2020 50
Friday, 3/13/2020 Sunday, 3/31/2019 Sunday, 3/1/2020 Sunday, 3/8/2020 50
Saturday, 3/14/2020 Sunday, 3/31/2019 Sunday, 3/1/2020 Sunday, 3/8/2020 50
Sunday, 3/15/2020 Sunday, 3/31/2019 Sunday, 3/1/2020 Sunday, 3/15/2020 51
Monday, 3/16/2020 Sunday, 3/31/2019 Sunday, 3/1/2020 Sunday, 3/15/2020 51
Tuesday, 3/17/2020 Sunday, 3/31/2019 Sunday, 3/1/2020 Sunday, 3/15/2020 51
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Wednesday, 3/18/2020 Sunday, 3/31/2019 Sunday, 3/1/2020 Sunday, 3/15/2020 51
Thursday, 3/19/2020 Sunday, 3/31/2019 Sunday, 3/1/2020 Sunday, 3/15/2020 51
Friday, 3/20/2020 Sunday, 3/31/2019 Sunday, 3/1/2020 Sunday, 3/15/2020 51
Saturday, 3/21/2020 Sunday, 3/31/2019 Sunday, 3/1/2020 Sunday, 3/15/2020 51
Sunday, 3/22/2020 Sunday, 3/31/2019 Sunday, 3/1/2020 Sunday, 3/22/2020 52
Monday, 3/23/2020 Sunday, 3/31/2019 Sunday, 3/1/2020 Sunday, 3/22/2020 52
Tuesday, 3/24/2020 Sunday, 3/31/2019 Sunday, 3/1/2020 Sunday, 3/22/2020 52
Wednesday, 3/25/2020 Sunday, 3/31/2019 Sunday, 3/1/2020 Sunday, 3/22/2020 52
Thursday, 3/26/2020 Sunday, 3/31/2019 Sunday, 3/1/2020 Sunday, 3/22/2020 52
Friday, 3/27/2020 Sunday, 3/31/2019 Sunday, 3/1/2020 Sunday, 3/22/2020 52
Saturday, 3/28/2020 Sunday, 3/31/2019 Sunday, 3/1/2020 Sunday, 3/22/2020 52
DT FISCAL_YEAR_START FISCAL_MONTH_START FISCAL_WEEK_START WEEK_NUMBER
---------------------- ---------------------- ---------------------- ---------------------- -----------
Sunday, 3/29/2020 Sunday, 3/31/2019 Sunday, 3/1/2020 Sunday, 3/29/2020 53
Monday, 3/30/2020 Sunday, 3/31/2019 Sunday, 3/1/2020 Sunday, 3/29/2020 53
Tuesday, 3/31/2020 Sunday, 3/31/2019 Sunday, 3/1/2020 Sunday, 3/29/2020 53
366 rows selected.
SQL>
SY.
|
|
|
|
Goto Forum:
Current Time: Sat Jun 15 17:58:02 CDT 2024
|