Date with hours (Filter)

[ryotaro999]

Hello!

I have a data with dates and hours. I need a filter that show me dates yesterday after 2:00 PM.

I'm trying with Filter tool but it hasn't option with hours.

Thanks.

[Jonathan-Sherman · Accepted solution]

Hi @ryotaro999,

You could use:

DateTimeDiff(DateTimeToday(),[DateTime],'day') <= 1 AND DateTimeHour([DateTime]) >= 14

Input:

True Output:

False Output:

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan

[ryotaro999]

Thank you very much for your quick answer!

It worked the way I wanted it to work.)

Thank you .