where date is older than today

Clinton · 2024-02-27T10:24:24.462+00:00

I'm trying to create a formula that look at a data set and returns true if there are records where the date field is older than today. Any help will be appreciated.

Clinton

1 year ago

I'm trying to create a formula that look at a data set and returns true if there are records where the date field is older than today. Any help will be appreciated.
gazinhio

1 year ago

You just want to return true or false if the condition is met or you want to filter out/in just those dates that are older than today's date?

Are you getting the data from an API and what format are the dates returned in?
noCode.Lad

1 year ago

I find that converting the date to unix is way easier to use and visualise; though using the dates as is will still suffice.

You simply have to have an "Greater than" or "less than" formula which takes in the date you want to compare (probably from the repeated item or a variable, and then compare it to the formular "Now"
Clinton

1 year ago

Thanks for the updates - I managed to solve in the end by converting the dates to Timestamp and Filtering all the dates Less Than into a new array.

where date is older than today

Clinton

gazinhio

noCode.Lad

Clinton