BUG: Unable to convert value #date(2022, 9, 26) to type Number

[Syndicate_Admin]

Good morning

I consult, I want to make dynamic this restriction in the Date field (this as Date / time)

each [FECHA] >=
#datetime(2022, 3, 1, 0, 0, 0))

each [FECHA] >=
#date(Date.AddDays(DateTime.Date(DateTime.LocalNow()), -30), 0, 0))

Porbe in this way but I the following error:

Expression.Error: Unable to convert the value #date(2022, 9, 26) to the Number type.
Details:
Value=26/9/2022
Type=[Type]

Thanks a lot.

[johnt75 · Accepted solution]

If you don't need the time part of the [FECHA] column then you could convert it to a Date type before you execute this step. If you do need the time part you could use

each [FECHA] >=
DateTime.From(Date.AddDays(DateTime.Date(DateTime.LocalNow()), -30))

[Syndicate_Admin]

This option worked correctly.
Thanks a lot

[johnt75]

Try

each [FECHA] >=
Date.AddDays(DateTime.Date(DateTime.LocalNow()), -30)

[Syndicate_Admin]

Try and give the following error:

Expression.Error: Unable to apply the < operator to the Date and DateTime types.
Details:
Operator=<
Left=26/9/2022
Right=1/1/2022 00:00:00