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....
I know this thread is old but I think your formula is correct but your dataset is wrong. Periods 11 and 12 are both 13 months long. The from dates for 11 and 12 are both in 22 instead of 23.