Help needed with Date and Time Stamp and API

Topic Labels: API
2583 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I would like my PDF’s URLs to come in thru the API at a certain date and at a certain time and then expire but I either get zero records as my result or only the first one comes in but not at the time it should. I’m not sure if I need to use the Now formula with this:

AND({Start Date}<=“2018-26-10T8:45:00.000Z”,{Expiration Date}>=“2018-26-10T8:50:00.000Z”)

This is what I’m using right now when I request URL:{Start Date}<=“2018-26-10T9:45:00.000Z”,{Expiration Date}>=“2018-26-10T9:50:00.000Z”)

This is my airtable

Also, this is what I chose for the date and time format


This is the script I’m using:


Has anyone had an issue with Date and Time scheduling that can help me? I would really appreciate it.

Thank you in advance.

2 Replies 2
8 - Airtable Astronomer
8 - Airtable Astronomer

You will probably want to look into the use of the IS_AFTER and IS_BEFORE formula

Check out the link below for a more detailed explanation of the above formulas.


I did some tests on these formulas and I’m not sure they are able to compare dates including a timestamp. Will these formulas enable to a make a filter on dates and the hour (or even minute in this case?) level? Please advise. Thank you - Teresa