Date smaller than first day of current month

[Samhunt]

Hello Everyone, 

I am new to this so I require some help. 

Because I add my data on the first days of next month I want to create a column Query that will mark all dates that are smaller than the first day of the current month to be marked as past and all the dates in the current month and onward to be marked as future

So this is what I tried which is wrong as I received an error in my column

=if [date] < Date.StartOfMonth(DateTime.LocalNow()) then "Past" else "Future"

So for example now we have February, I want in the new column all dates before the 01/02/2024 to be marked as past

Thanks for your time

[dufoq3 · Accepted solution]

The issue is with  DateTime.LocalNow(), because it is as datetime - just add Date.From before it.

if Date.From([date]) < Date.StartOfMonth(Date.From(DateTime.LocalNow())) then "Past" else "Future"

[Samhunt]

Hi @dufoq3 

Works as a charm thank you very much really appreciated