Custom Column Formula Error - not getting expected results

[Anonymous]

Hi Experts

I have the following Custom Column Formula

if [Sales Date] >= Date.StartOfMonth(Date.AddMonths(Date.From(DateTime.LocalNow()),-1)) and [Date] <= Date.EndOfMonth(Date.AddMonths(Date.From(DateTime.LocalNow()),-1))
then "Actual" else "4YOP"

When i add the new column it give me dates that are in 2012, 2021 (jan) as "4YOP" when they should be Actual and Feb 21, Mar 21 and April 21 as Actuals...

All Future dates i.e March onwards should be "4YOP" and all historical dates "Actuals"....

[amitchandak · Accepted solution]

@Anonymous ,

if  [Sales Date] <= Date.EndOfMonth(Date.AddMonths(Date.From(DateTime.LocalNow()),-1))
then "Actual" else "4YOP"