How do I use Date-Time fields with conditional operators?

Options
Kevin_102667
Kevin_102667 Posts: 56 admin
edited October 2019 in Questions

What's the proper way to reference and create condition code with comparison operators when processing Date and Time fields from a table?

Example: I wanted to filter this table and find all date times after "2019-09-29 7:00 PM"

This is how my example table displays in the UI:

Approval Date
2019-09-29 7:00 PM
2019-09-30 7:00 PM
2019-12-03 6:00 PM
2019-11-01 7:00 PM

This is same table with the value of the date-times in ISO 8601 time

Approval Date
2019-09-30T00:00:00.000Z
2019-10-01T00:00:00.000Z
2019-12-04T00:00:00.000Z
2019-11-02T00:00:00.000Z

When I use a Tables: Apply Filters step with this advanced filter logic, I get the below output. The first row should not have been included in the output
columns[1] > "2019-09-29 7:00 PM"

Screenshot

Tagged:

Categories