I am trying to filter features shown on the Map using definition expression. I want to filter between start and end time stamps. The definition expression set on the feature layer is "event_timestamp BETWEEN TIMESTAMP <start_timestamp> AND TIMESTAMP <end_timestamp>".
The problem I am facing is that the filtering does not happen correctly if both start and end timestamps are in local timezone (Asia/Kolkata) or UTC timezone.
But if I convert only start_timestamp to UTC (by subtracting 5 hrs and 30 mins to local time) and keep end timestamp in local timezone, the filtering happens correctly. Why is it so?
Do I need to convert the timestamps to UTC or should I work with local time zone? Why is it that filtering works correctly only if start_timestamp is converted but end_timestamp is not?
