Date Range

[ANARK]

Hi Team - I have data with Orders and its booked date, need to refer a sheet for the date range and return cutoff number. The start and end date keeps changing and will be maintained in an excel. So dont want to use the date directly in the workflow, instead it has to be taken from the updated excel. Any logic that will work?

Table1:

Order.Nos	Ord Dt
1	1/2/2024
2	1/28/2024

Excel input:

Start Date	End Date	Cutoff
1/1/2024	1/10/2024	1
1/11/2024	1/20/2024	2
1/21/2024	1/30/2024	3

Combined Data:

Order.Nos	Ord Dt	Cutoff
1	1/2/2024	1
2	1/28/2024	3

[alexnajm · Accepted solution]

Here's an article that shows you how to do it: How to Join on a Date Range

[alexnajm]

Another way: How To: Join on Ranges in SQL and Alteryx