URL Filter: works by date - breaks by time

[loukas]

Hello! 
This filter does not take into account the time part when applied in URL: 

filterGreaterOrEqual_Date=2023-10-17T22%3A00%3A00.000Z

Except for when I set it at 22:00 where it filters OUT all records with date October 17, 2023 and "allows" them back in when I set it to 21:59.

Other settings such as 06:00:00.000Z or 18:00:00.000Z show every record of October 17. 

Dates on my table are:
17 October 2023 00:00 UTC
17 October 2023 00:00 UTC
17 October 2023 10:00 UTC
17 October 2023 10:30 UTC
17 October 2023 22:30 UTC

If I remove the time altogether it catches Dates very well: filterGreaterOrEqual_Date=2023-10-17 works fine. 

Any Ideas please? 

[Sho · Accepted solution]

Hi @loukas ,

Indeed, the URL filter seems to ignore the time if it is a date type.

One idea is to add a formula field and the formula is

VALUE(DATETIME_FORMAT({Date}, "X"))

These numbers are comparable because they include time down to the second.