Search Records Is Today condition is broken
Hi, when using the 'Search Records' action and the 'Is Today' condition, the output only shows the date of creating or modifying the workflow.
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)
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)
