Filtering a specific date by NOW

[Anonymous]

Hello,

I need to filter a date by NOW function, for exemple dat_registrer < NOW ().

Below I am filtering a specific date, I need to replace with NOW:

= Table.SelectRows(#"Filtered Lines1", each [dat_registrer] < #datetime(2022, 10, 11, 0, 0, 0))

How i do that?

[v-xiaosun-msft · Accepted solution]

Hi @Anonymous ,

According to your description, here is my soluton.

Please try

= Table.SelectRows(#"Filtered Lines1", each [dat_registrer] < DateTime.FixedLocalNow())

This will return a datetime value set to the current date and time on the system.

Please refer to the following documents.

DateTime.FixedLocalNow - PowerQuery M | Microsoft Learn

DateTime.LocalNow - PowerQuery M | Microsoft Learn

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.