Forum Discussion
Solved
Custom Column If statement using todays date + 60 days
Hi All, Im trying to create a custom column which looks to see if an existing column is less the todays date + 60 days and will return text in new column saying "over" or "under" I wrote the ...
Actually was able to solve it my self. Using the following:
if [Valid until] < Date.AddDays(Date.From(DateTime.LocalNow()),60) then "under" else "over"
Assuming "Valid until" is a date data type field, try this ...
Date.From(DateTime.LocalNow())