Forum Discussion
Filtering a specific date by NOW
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?
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 _ xiaosunIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
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 _ xiaosunIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.