Forum Discussion
Solved
Identify if today's date is between 2 dates
Hi. I have created a column in Query Editor for today's date... = Table.AddColumn(#"Added Custom", "Today's Date", each DateTime.LocalNow() as datetime) From that I would like to identify...
Hi
Attempt 1...
Date.From([#"Today's Date"])
= Table.AddColumn(#"Changed Agreement Start/End dates from date/time to date", "Custom 2",
each if Date.From([#"Today's Date"]) >= Date.From([Agreement Start Date]) and
Date.From([#"Today's Date"]) <= Date.From([Agreement End Date]) then "Active" else "Inactive")Stéphane
