Hi @Umapathi_PATANA - I’m assuming from your question that you are using the AT API. If so, you need to apply a filterByFormula
parameter to your API call. Not exactly the same as your scenario, but this works for me:
https://api.airtable.com/v0/YOUR_APP_ID/YOUR_TABLE_NAME?maxRecords=3&view=YOUR_VIEW&filterByFormula=IS_AFTER(%7BYOUR_DATE_FIELD%7D, '2019-01-01')
So some combination of IS_AFTER and IS_BEFORE should do the trick.
(Aside - the %7B
and %7D
characters are curly braces encoded for the URL)
JB
Hi @Umapathi_PATANA - I’m assuming from your question that you are using the AT API. If so, you need to apply a filterByFormula
parameter to your API call. Not exactly the same as your scenario, but this works for me:
https://api.airtable.com/v0/YOUR_APP_ID/YOUR_TABLE_NAME?maxRecords=3&view=YOUR_VIEW&filterByFormula=IS_AFTER(%7BYOUR_DATE_FIELD%7D, '2019-01-01')
So some combination of IS_AFTER and IS_BEFORE should do the trick.
(Aside - the %7B
and %7D
characters are curly braces encoded for the URL)
JB
Also, I would format the date field “YYYY-MM-DD”. It might work with your format, but possibly safer to go with the above (you could have another date field formatting the first, just for the API, if you need your format above in the UI).
Hi @Umapathi_PATANA - I’m assuming from your question that you are using the AT API. If so, you need to apply a filterByFormula
parameter to your API call. Not exactly the same as your scenario, but this works for me:
https://api.airtable.com/v0/YOUR_APP_ID/YOUR_TABLE_NAME?maxRecords=3&view=YOUR_VIEW&filterByFormula=IS_AFTER(%7BYOUR_DATE_FIELD%7D, '2019-01-01')
So some combination of IS_AFTER and IS_BEFORE should do the trick.
(Aside - the %7B
and %7D
characters are curly braces encoded for the URL)
JB
Actually, not even sure you need the curly braces. It works without.