Recently came across a scenario where we had to query CRM and retrieve accounts based on UTC date. After a fair bit of research, came-up with a Fetch query that can retrieve records based on time and time zone filters.
In the below date, +00.00 stands for UTC Time Zone and we can use any timezone by modifying this part.
Below is a sample fetchxml, which retrieve records with modifiedon greater than or equal to given UTC datetime.
Note: Use 'greater than or equal to' or 'lesser than or equal to' instead of 'on or before' or 'on or after'
To filter time based on user's timezone remove the timezone part(+00:00) from the query and the sample will look like below,
Hope this helps!