Filter records on date time field dynamically in power query

[saxena_mk]

Hi

I need help below query filter to dynamic dare and time filter in power query excel so that I can filter records of DATE column between a time range given dynamically taking today’s date from 5 Am and tomorrow date 4 AM.
I am doing this manually though following query which is a manual process to filter every day changing date . How can I make it dynamic to take dates dynamically:

#"Filtered Rows" == Table.SelectRows(#"Changed Type", each [DATE] > #datetime(2018, 6, 29, 5, 0, 0) and [DATE] < #datetime(2018, 6, 30, 4, 0, 0))

[Olly]

Use this:

Please Login or Register  to view this content.

[saxena_mk]

Thanks a lot! Olly!

Great ! thanks a lot for quick reply.

The problem is solved....

[Olly]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. You may also 'Add Reputation' to those who helped you. Thanks.