Create custom colum value based on detes between a range in two seperate date columns

[rs101]

 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. Can anyone help

[ovde · Accepted solution]

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)

[rs101]

Thanks that gave me enough information to help me solve the issue!