Location_timestamp definition query for current_timestamp-0.5 does not work on location tracking layer
This definition query on the location tracking layer that sits in AGOL works in ArcMap and does not work (Attribute Table is blank, no records returned) in ArcGIS Pro version 3.3 and version 3.4.
location_timestamp >= (current_timestamp-0.5)
Can someone verify that this query (for curent_timestamp-0.5) does or does not work for them when used in the definition query in ArcGIS Pro for the location sharing layer that is located in AGOL?
Details: I need to switch to ArcGIS Pro by the end of the year and this is a glitch in our workflow. I'm in ArcGIS Pro version 3.3 right now because version 3.4 kept crashing when I tried editing and version 3.3 seems more stable. This query returns records on other layers sitting in AGOL, just not on the location sharing layer (created via My Tracks in Field Maps). I want to select records created in the last 12 hours without the field crew having to figure out what UTC date and time is to get all their records on a daily basis. The definition query (location_timestamp < current_timestamp) returns records without the -0.5.
