I have a query in my workflow and I am using an expression
DateOnly(@START_DATE) greater than or equal to DateOnly(DaysAgo(14)).
When the query runs, for a few records which fall on Daylight saving time shift, is throwing an error.
Tried to use ToDate(@START_DATE) as well, and still the same issue.
Can someone assist on how to get rid of this.
Can you psot a screenshot of your workflow or the activity throwing the error to check how it's configured?
Issue was because of a few records which were present in the database which were in the Daylight saving time difference. Deleted those records and now the workflow runs fine without any issue.