Help needed with Date and Time Stamp and API


#1

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:

https://api.airtable.com/v0/appwTRS4obTixysow/Ad?api_key=mykeynumber&filterByFormula=AND({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

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.


#3

Hello,

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