Help needed with Date and Time Stamp and API

[Teresa_Rusnak]

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.

[Andrew_Johnson1]

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.

Airtable - Support

Formula field reference

For an overview of formula fields, please refer to the Guide to Formula, Lookup, Count, and Rollup fields. Formulas may involve functions, numeric operations, logical operations, and text operation...

[Teresa_Rusnak]

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