Pull in Result from range of data in seperate input data

Question

Hi, I have two sets of input data.  The first data set has a column with settlement dates as shown in the first grab below.  The second is assigning date ranges to specified periods as shown in the second grab below. I am trying to run a formula so that if the STTL_DATE is >= Period Begin and <= Period End that it pulls into a new column with the corresponding Period field from the second set.  Most solutions I am seeing call for a join tool but I cannot get this to work as there are no fields that join since I am looking for between a set of values.  I'm still learning and hope to give back once I do, thank so much!

STTL_DATE10/30/202012/15/202012/20/202009/01/2020

PeriodPeriod BeginPeriod EndP7 20208/1/20208/28/2020P8 20208/29/20209/25/2020P9 20209/26/202010/30/2020P11 202011/28/202112/25/2021P10 202010/31/202011/27/2020P11 202011/28/202012/25/2020

Luke_C · Accepted Answer

@Jon12

You can use a generate rows tool to create a record for each day in the period, and then join that up with the dates in your first table to figure out what period they are in. See attached example.