Answered

DateTime filter not working correctly

(0) Share

Report

Posted on by BS-31012226-0

I'm using the DateTime.IsInPreviousNHours() in Power Query to filter out files older than 14 days (336 hours). I'm seeing an issue where it's mistakenly filtering out files that have a very recent timestamp. See the before and after screenshots below where the 2 most recent files are being filtered for some reason.

Categories:

Power Query

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

SpongYe 5,616 Super User 2025 Season 2 on at

Like (2)

Report

Hi @BS-31012226-0

You are missing the 2 records of 1700 and 1715 because the Date modified is within the current hour.

Please check the documentation of the function DateTime.IsInPreviousNHours.

"Indicates whether the given datetime value dateTime occurs during the previous number of hours, as determined by the current date and time on the system. Note that this function will return false when passed a value that occurs within the current hour."

Hope this help you.

Was this reply helpful? Yes No
Verified answer

BS-31012226-0 4 on at

Like (0)

Report

@SpongYe - Ahh, thank you very much! I see now it's essentially taking the floor of the hour, rather than the entire timestamp, so anything in the current hour would get filtered out. I've changed it to use DateTime.IsInPreviousNMinutes() and it's picking up the recent files now.

Was this reply helpful? Yes No