Help

How to filter record by 'The last twenty-four hours ' by 'airtable.js'?

Topic Labels: Dates & Timezones
1646 3
cancel
Showing results for 
Search instead for 
Did you mean: 
gao_jie
5 - Automation Enthusiast
5 - Automation Enthusiast

image

I can’t find the right one 。

btw,how to use the filter(like above image) by the [airtable.js ] [select api][ filterByFormula ].(I can’t find a suitable document)

Please!

3 Replies 3

Try a formula like …

DATETIME_DIFF(TODAY(), CREATED_TIME(), 'days') <= 2 

You may need to play around with the number of days, and you may have issues with timezones. If you want more granular control, you could use something like …

DATETIME_DIFF(NOW(), CREATED_TIME(), 'hours') <= 48 
gao_jie
5 - Automation Enthusiast
5 - Automation Enthusiast

thanks a lot!
Can you please tell me how to use it in airtable.js or is there a documentation for it, I tried to find it but couldn’t.
sorry for any inconvenince caused

You can see the documentation here. You need to be logged into your Airtable account in the web browser, and the documentation will reflect your actual base.

Build the formula as a text string, and then pass the formula as the filterByFormula parameter when you select records.