Forum Discussion
Solved
Create custom colum value based on detes between a range in two seperate date columns
I am wanting to create a column with with year of value of '2023' in it if e_start date <= 31st July 2023 and if the e_end is between the dates of >= 1st August 2022 and <= to the 31st July 2023...
Something like this should work.
Table.AddColumn(#name of previous step, "Year", each if [e_start] <= #date(2023, 7 ,31) and [e_end] >= #date(2023, 8, 1) and [e_end] <= #date(2023, 7, 31) then 2023 else null)
