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 Go to next message
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 #612380 is a reply to message #612379] Thu, 17 April 2014 06:17 Go to previous messageGo to next message
Solomon Yakobson
Messages: 3269
Registered: January 2010
Location: Connecticut, USA
Senior Member
CEIL((DT - DATE '2014-04-01') / 7)

SY.
Re: getting finacial week number [message #612381 is a reply to message #612380] Thu, 17 April 2014 06:31 Go to previous messageGo to next message
guddu_12
Messages: 227
Registered: April 2012
Location: UK
Senior Member
but i need to hard code the date in the above answeered , the year will be randaom
Re: getting finacial week number [message #612382 is a reply to message #612381] Thu, 17 April 2014 06:42 Go to previous messageGo to next message
Solomon Yakobson
Messages: 3269
Registered: January 2010
Location: Connecticut, USA
Senior Member
And how diffinct that would be???

CEIL((DT - ADD_MONTHS(TRUNC(ADD_MONTHS(DT,-3),'YY'),3)) / 7)

SY.
Re: getting finacial week number [message #612384 is a reply to message #612380] Thu, 17 April 2014 07:21 Go to previous messageGo to next message
dariyoosh
Messages: 538
Registered: March 2009
Location: France
Senior Member
Solomon Yakobson wrote on Thu, 17 April 2014 13:17
CEIL((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 #612390 is a reply to message #612384] Thu, 17 April 2014 07:48 Go to previous messageGo to next message
guddu_12
Messages: 227
Registered: April 2012
Location: UK
Senior Member
Very nice answer, much appriciated
Re: getting finacial week number [message #612393 is a reply to message #612384] Thu, 17 April 2014 09:24 Go to previous messageGo to next message
Solomon Yakobson
Messages: 3269
Registered: January 2010
Location: Connecticut, USA
Senior Member
dariyoosh wrote on Thu, 17 April 2014 08:21
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.


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 #612404 is a reply to message #612379] Thu, 17 April 2014 12:52 Go to previous messageGo to next message
are_we_there_yeti
Messages: 2
Registered: April 2014
Location: South Carolina
Junior Member
Sounds like you want an ISO date.
http://www.epochconverter.com/epoch/weeknumbers.php

...if so, use a date format of 'IW'
select to_char(sysdate,'IW') from dual;

[Updated on: Thu, 17 April 2014 12:55]

Report message to a moderator

Re: getting finacial week number [message #612405 is a reply to message #612404] Thu, 17 April 2014 14:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Sounds like you are wrong.

Re: getting finacial week number [message #612406 is a reply to message #612393] Thu, 17 April 2014 14:58 Go to previous messageGo to next message
dariyoosh
Messages: 538
Registered: March 2009
Location: France
Senior Member
Solomon Yakobson wrote on Thu, 17 April 2014 16:24
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:

. . .

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 ! Sad Sad

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 Go to previous messageGo to next message
Solomon Yakobson
Messages: 3269
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 #612408 is a reply to message #612405] Thu, 17 April 2014 15:43 Go to previous messageGo to next message
are_we_there_yeti
Messages: 2
Registered: April 2014
Location: South Carolina
Junior Member
Aw.... I didn't RTFQ. I saw financial week and jumped to the wrong conclusion.

You are right, I am wrong.

I vote myself off this particular island.
Re: getting finacial week number [message #612409 is a reply to message #612407] Thu, 17 April 2014 16:21 Go to previous messageGo to next message
dariyoosh
Messages: 538
Registered: March 2009
Location: France
Senior Member
Solomon Yakobson wrote on Thu, 17 April 2014 22:26
... It gives last monday prior or equal to 1st day of fiscal year ...


Thanks a lot for the clarification. Smile
Re: getting finacial week number [message #679813 is a reply to message #612382] Tue, 31 March 2020 11:13 Go to previous messageGo to next message
danielarias
Messages: 2
Registered: March 2020
Junior Member
Hi Salomon,

I must do the same, but the week for me starts on Sundays and ends on Saturdays.

for example: Week 1 of a month start on the Sunday of a week where the day 01 of the calendar month is. April 01 2019 is on the Monday so the Week 1 in the report will start on the 31st of March (Sunday).

Please tell me how I can make the exact calculation.

Thank you.

Daniel.
Re: getting finacial week number [message #679822 is a reply to message #679813] Thu, 02 April 2020 10:43 Go to previous messageGo to next message
Solomon Yakobson
Messages: 3269
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.
Re: getting finacial week number [message #679839 is a reply to message #679822] Sun, 05 April 2020 11:16 Go to previous message
danielarias
Messages: 2
Registered: March 2020
Junior Member
Thank you Salomon for the answer, it worked out very well.
Previous Topic: How To Add Full Email Body Text from File to CLOB Column?
Next Topic: Adding a from () to a query made it so slow
Goto Forum:
  


Current Time: Thu Mar 28 08:56:05 CDT 2024