AnsweredAssumed Answered

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

Question asked by leftieant76 on Nov 13, 2018
Latest reply on Nov 17, 2018 by shantanu9031

Hello

 

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?

Outcomes