Skip to main content

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

  • June 10, 2021
  • 3 replies
  • 35 views
G

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

    kuovonne
    Forum|alt.badge.img+29
    • kuovonne
    • Brainy
    • June 10, 2021

    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
      G
      • gao_jie
      • Author
      • New Participant
      • June 15, 2021

      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

      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

      kuovonne
      Forum|alt.badge.img+29
      • kuovonne
      • Brainy
      • June 15, 2021

      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.

        Terms & ConditionsAccessibility statement