Date Time Where Conditions For API's

APIs
1

The current date is 13.05-2025 14:13.00. I want to filter by a column that is between two date times and I am using activepieces. How can I find that a column with the CreatedAtCustom field name of 12.05-2025 14:13.00 and 13.05-2025 14:13.00 is within this date range?

2

Hi @eyyupsert

To filter records by a column with a date-time range, use our where query param in your API query.

For exact date filtering you can use lt / gt with date range:

GET /api/v2/tables/{tableId}/records?where=(CreatedAtCustom,lt,exactDate,2025-05-14 14:00)~and(CreatedAtCustom,gt,exactDate,2025-05-12 14:00)

For dynamic filtering like today - tomorrow etc. you can do something like following:

GET /api/v2/tables/{tableId}/records?where=(CreatedAtCustom,eq,today)~or(CreatedAtCustom,eq,tomorrow)

For more details see the NocoDB REST API Overview

3

Thanks man. It worked.

2 Likes