Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Find records with date field equal to now not working

Topic Labels: Formulas
480 0
cancel
Showing results for 
Search instead for 
Did you mean: 

So I am attempting to use the api (via the npm client) to find records that are now or in the past, then perform an action, and mark them as complete (mark completed column as true). Select is as follows:

view: 'Scheduled',
filterByFormula: `DATETIME_DIFF({Game Start}, NOW(), 'minutes') <= 0`,

The formula works fine for records in the past, but not for when the times are equal. For instance, if it is 8:25am and the ‘Game Start’ is also 8:25am, it is not coming back as a result, but when it is ran at 8:30am, it does return as a result. Not sure if it’s a timezone difference, formula issues, or what.

Any help would greatly be appreciated. Thanks!

0 Replies 0