Forum Discussion
Solved
If date is between 2 dates from another table return value
I have a DateTable with a list of dates and then I have the table below with fiscal year data: I'm trying to add columns to the DateTable to reflect the data from this fiscal year table....
Hi ryan_mayu,
I'm trying to take a date table with a list of dates:
And a fiscal calendar with various data points like the number of ship days in each period:
| Fiscal Year | Period | FY Period | FY Period Dates | Start Date | End Date | Ship Days |
| FY23 | P01 | FY23 P01 | FY23 P01 (2/28-4/3) | 2/28/2022 | 4/3/2022 | 25 |
| FY23 | P02 | FY23 P02 | FY23 P02 (4/4-5/1) | 4/4/2022 | 5/1/2022 | 20 |
| FY23 | P03 | FY23 P03 | FY23 P03 (5/2-5/29) | 5/2/2022 | 5/29/2022 | 20 |
| FY23 | P04 | FY23 P04 | FY23 P04 (5/30-7/3) | 5/30/2022 | 7/3/2022 | 24 |
| FY23 | P05 | FY23 P05 | FY23 P05 (7/4-7/31) | 7/4/2022 | 7/31/2022 | 19 |
| FY23 | P06 | FY23 P06 | FY23 P06 (8/1-8/28) | 8/1/2022 | 8/28/2022 | 20 |
| FY23 | P07 | FY23 P07 | FY23 P07 (8/29-10/2) | 8/29/2022 | 10/2/2022 | 24 |
| FY23 | P08 | FY23 P08 | FY23 P08 (10/3-10/30) | 10/3/2022 | 10/30/2022 | 20 |
| FY23 | P09 | FY23 P09 | FY23 P09 (10/31-11/27) | 10/31/2022 | 11/27/2022 | 19 |
| FY23 | P10 | FY23 P10 | FY23 P10 (11/28-1/1) | 11/28/2022 | 1/1/2023 | 24 |
| FY23 | P11 | FY23 P11 | FY23 P11 (1/2-1/29) | 1/2/2022 | 1/29/2023 | 19 |
| FY23 | P12 | FY23 P12 | FY23 P12 (1/30-2/27) | 1/30/2022 | 2/27/2023 | 20 |
And combine them so the data from the fiscal calendar is added to the date table based on the Date (column A of the Date table) falling between the Start and End dates in the Fiscal Calendar: