Querying a Feature service from AGOL on the CreationDate field

4455
2
Jump to solution
03-03-2015 06:43 AM
JohnSchulz
Deactivated User

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.

This widget could not be displayed.
This widget could not be displayed.
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

This widget could not be displayed.
This widget could not be displayed.
2 Replies
JakeSkinner
Esri Esteemed Contributor

Hi John,

Try the date in the following format:

mm/dd/yyyy

Ex:

created_date < '3/3/2015'

This widget could not be displayed.
This widget could not be displayed.
JohnSchulz
Deactivated User

Many Thanks!!

John Schulz

GIS Analyst SR

Geospatial Analysis & Data Development Services

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

(512)972-0198

This widget could not be displayed.
This widget could not be displayed.