Allow time filtering based on predefined timezone
We've noticed that an admin can set and change the account timezone. When doing API calls including time components (such as time filtering), these time components have to be defined in that selected timezone.
This is a bit inconvenient as we cannot be sure that the initial timezone will be kept. Technically we could fetch the current timezone setting for every API call with time filtering that we do (at least 1 every five minutes), but this is not very API efficient.
Simply relying on the fact that the timezone will remain unchanged is also not 100% safe, although it's indeed not a very current event.
Would there be any possibility that you could allow us to do time filtering based on a provided timezone? This could be done in multiple ways:
1. Allow us to provide the timezone as part of the datetime value. For instance: /Contacts/?$async=false&$filter=LastUpdated ge 2017-10-18T00:27:51+00:00 )?
2. Allow us to provide an additional parameter to the filter which would allow us to specify the time zone (for instace "GMT").
Wout De Geyter
shared this idea
-
The forst option is completely possible, use the following date format "2018-05-28T11:55:00.543+03:00"
