Issue with Search Function in Automation
I am almost certain that I have found a bug in the use of the Search feature in automation. I have an app (“Data Reserva”) that includes a start date and an end date (non-overlapping periods). I need to find a period where a given date fits, meaning the start of the period is before the reference date, and the end of the period is after the reference date.
In the app, the filter works perfectly, but in the automation, there is an error where it fails to find the record when the date is exactly one day after the start date. I am in GMT-3 and believe there might be a time zone issue affecting the dates.
Steps to Reproduce:
- Open the “Data Reserva” app.
- Set a non-overlapping period with a start date and end date.
- Try to search for a record in automation with a date one day after the period’s start date.
- Observe the behavior in the app versus in automation.
Expected Result: The record should be found successfully in automation, just as it works in the app.
Actual Result: In automation, the record is not found when the reference date is one day after the start date.
Additional Information: I am located in the GMT-3 timezone, and the issue could be related to time zone handling in the automation process.
