twenty
twenty copied to clipboard
Search Records Is Today condition is broken - Only updates when created or modified
Bug Description
Hi, when using the 'Search Records' action and the 'Is Today' condition, the output only shows the date of creating or modifying the workflow.
Example:
Using my Google Chat integration as an example.
Trigger - Schedule - Daily -> Action - Search Records - Object People - Conditions Where Follow Up Date (Custom field in people data model just date selection) Is Today - Limit 30 -> Action - Iterator - All People -> Loop -> HTTP Request - POST - Raw JSON { "text": "iterator.firstname iteratior.lastname iterator.email" }
Seems simple, but every day when the workflow is automatically run, it will output data from the 26th (when the workflow was created). Sometimes it will output correct data on a test run, but that's normally after updating the workflow (which counts as modifying, so the date updates to that moment)
<img width="904" height="554" alt="Image" src="https://github.com/user-attachments/assets/4ece4eb0-29e3-46f1-a319-c1c346f6547b" />
Expected behavior
When Search Records is triggered, it should out put data relating to the current date rather than data related to the date that node was created or updated.
Selfhosting the most recent version by the way.