Help

Date Search Formula Not Working

Topic Labels: Formulas
2860 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Matthew_Ross
5 - Automation Enthusiast
5 - Automation Enthusiast

I am attempting to get all of the entries between two different dates. One date is the creation date of an entry and the other is today’s date. After doing a little bit of searching I figured it would be something like

filterByFormula=AND(IS_AFTER({Start Date},IS_BEFORE(NOW()))

But when I try using this via the API and filterByFormula it says invalid formula. I am not sure where it’s going wrong as I am super new to all of this and was hoping someone would have an idea or two.

I also tried to include the date after the is_after and is_before but it came back as invalid.

AND(IS_AFTER({Start Date}, {{INSERTDATE}}), IS_BEFORE({Start Date}, {{now}})

Oh and I should specify the Start Date in the formula is being pulled directly from the API response with the creation date in it.

2 Replies 2
Matthew_Ross
5 - Automation Enthusiast
5 - Automation Enthusiast

Short update but I was able to get the formula to be considered a valid one so it would not return an error by removin the AND but now it is pulling all the values in the table. Which is definetly not the idea lol

Matthew_Ross
5 - Automation Enthusiast
5 - Automation Enthusiast

Anyone have any suggestions?