I tried to set up the filter under Find Records to locate the records with Published Date = Today, but tried many times still not sccuess. Other filter options are working fine.
Any idea? thx
Hi @Keith, this is most likely related to a timezone mismatch in the date field.
Please try the following steps:
-
Go to your datasheet and open the Published Date field settings
-
Enable Show Time, and set the Timezone to match your current local timezone
-
Save and rerun your automation
If it’s still not working, feel free to share a screenshot of the automation run history so we can help troubleshoot further.
Let us know how it goes!