Filter Table using Date Time
Any tips on how to filter records based on a date-time stamp in one of the fields?
I have a table collecting logs and one field includes a date-time stamp in utc format ("2020-04-28T19:15:28.426Z"). The goal is to get all the records that were added in the last 24 hours.
I've tried using a combination of first adjusting a date-time value where I adjust the run-start-date by -24 hours and then applying that output into an advanced formula "column[2] > {{time-adjust}}".
However my filter is producing zero records even though there is data in the table from the last 24 hours. I suspect the problem is that the date time format from my time adjust isn't the same as the utc format in my logs table. Any tips on how I can make sure my filter formula works correctly?
Best Answers
-
Hey @Adam_636382,
The related help article includes a section specific to filtering dates. Does the information included there help answer this question? Please let me know. I will be happy to take a closer look.
How to filter dates
https://help.catalytic.com/docs/tables-apply-filters/#how-to-filter-dates5 -
I think I found that my problem was actually an error in my formula. I was using "column[2]" instead of "columns[2]". Now that it is corrected the formula is filtering records correctly. Thanks!
1
Answers
-
@Adam_636382 Glad to hear it!
0 -
@Adam_636382 Relevant product enhancement for you to upvote: Easier column references for data tables and spreadsheets
0