Querying a Feature service from AGOL on the CreationDate field

3815
2
Jump to solution
03-03-2015 06:43 AM
JohnSchulz
New Contributor II

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.

0 Kudos
1 Solution

Accepted Solutions
JakeSkinner
Esri Esteemed Contributor

Hi John,

Try the date in the following format:

mm/dd/yyyy

Ex:

created_date < '3/3/2015'

View solution in original post

2 Replies
JakeSkinner
Esri Esteemed Contributor

Hi John,

Try the date in the following format:

mm/dd/yyyy

Ex:

created_date < '3/3/2015'

JohnSchulz
New Contributor II

Many Thanks!!

John Schulz

GIS Analyst SR

Geospatial Analysis & Data Development Services

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

(512)972-0198

0 Kudos