Filter rows against dates and times

David_Juras · February 27, 2023, 6:49am

Hi,

I am looking to filter some rows against dates and times and to use parameters in expression to Filter by condition. For example, filter all rows that sit between 2019-03-21 09:40:04 and 2019-03-21 10:13:40.
How could it be done ? Did not find anything so far in Web help or Community, maybe I missed it.

Thanks and regards.

roberto · February 27, 2023, 8:59am

Hi @David_Juras,

In this case you will need to have 2 text parameters with the date-time in text, and then 2 calculated parameters that convert that text to an actual date. Then you can use those 2 calculated parameters in the filter.

I attach a sample project: Date-Time parameters.morph (2.8 KB)

Regards,

Roberto

David_Juras · February 28, 2023, 1:37pm

Hi Roberto. Thanks a lot !