Custom Column If statement using todays date + 60 days

[hdhillon]

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 following and I get an error:  Need your help please -->

if [Valid until] < DateTime.LocalNow() then "under" else "over"

[sevenhills]

Interesting that you are saying that you solved yourself ... good for you~

[hdhillon · Accepted solution]

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"

[sevenhills]

Date.AddDays(Date.From(DateTime.LocalNow()), 60)

The syntax is for M query 

[hdhillon]

How do I write the same equation but with todays date + 60 days.  I just tried this but get an error

if [Valid until] < Date.From(DateTime.LocalNow()) +60 then "under" else "over"

(Note Valid until is a date)

[sevenhills]

Assuming "Valid until" is a date data type field, try this ... 

Date.From(DateTime.LocalNow())