AnsweredAssumed Answered

Definition Queries on AGOL REST endpoint - query on time feature created

Question asked by leftieant76 on Nov 13, 2018
Latest reply on Feb 8, 2019 by wws_ahargreaves



I'm currently consuming a REST endpoint from ArcGIS Online in ArcMap. I would like to be able to apply a definition query to the layer to select records that are only (for example) less than 24 hours old. Editor tracking is enabled on the feature service, so I have automatically populated fields for 'CreationDate' and 'EditDate'. These times are recorded in UTC.


I cannot work out the SQL syntax to make this occur - in particular how to access 'current time' (which in my circumstance will need to be current time in UTC).



Is anyone able to assist with this?