Hello, I have a date time column that looks like this: “05.Jun.2020 10:58:35.893”. I want to filter my data to only return the lines that were in the previous 24 hour period. So If today is June 10th, I want only the lines from June 9th or 09.Jun.2020 00:00:00.000 to 09.Jun.2020 23:59:59.999. I’ve tried to use a few different DateTime nodes (like Date&Time Difference) and I get this error when I try to configure: The dialog cannot be opened for the following reason: No column in spec compatible to “LocalDateValue” “LocalTimeValue” “LocalDateTimeValue” or “ZoneDateTimeValue” Can someone please point me to correct way to handle this? Thank you

Thank you everyone! I figured it out! I used the “Date&Time-based Row Filter” and it works perfectly. [image]

Date Time Calculation help

ipazin June 18, 2020, 9:58am 13

See this topic:

Br,
Ivan

1 Like