topic Re: Querying a Feature service from AGOL on the CreationDate field in ArcGIS Online Questions

Querying a Feature service from AGOL on the CreationDate field

JohnSchulz — Tue, 03 Mar 2015 14:43:52 GMT

I am trying to query a feature service from ArcGIS Online. I want to query the service based on the CreationDate field. I know that this field is using the UNIX timestamps and is not a true date field. When ever I try query based on the current time example ( CreationDate < 1425393547)

I get the wonderful "Unable to perform query. Please check your parameters" error message. This begs the question can you query on the the CreationDate field and if so are there any examples out there? The ultimate goal here is to generate reports based on certain features in the feature service based on a time range.

Re: Querying a Feature service from AGOL on the CreationDate field

JakeSkinner — Tue, 03 Mar 2015 16:11:37 GMT

Hi John,

Try the date in the following format:

mm/dd/yyyy

Ex:

created_date < '3/3/2015'

Re: Querying a Feature service from AGOL on the CreationDate field

JohnSchulz — Tue, 03 Mar 2015 16:38:45 GMT

Many Thanks!!

John Schulz

GIS Analyst SR

Geospatial Analysis & Data Development Services

John.Schulz@austintexas.gov<mailto:John.Schulz@austintexas.gov>

(512)972-0198