topic Re: How do I create a select statement for datepart for a definition query in ArcGIS Online Developers Questions

How do I create a select statement for datepart for a definition query

ShaunHealy1 — Thu, 30 Jun 2016 18:57:11 GMT

Greetings! I'm trying to filter out a datepart to allow viewers to see features that have been placed on the map in the last few days. I have tried using SQL 92 supported statements for file gdb but no results. Any insight appreciated.

Re: How do I create a select statement for datepart for a definition query

Anonymous User — Thu, 30 Jun 2016 23:37:54 GMT

Hi Shaun,

You could try something like the following to specify a date range:

"DateField" >= date '05/01/2011 00:00:00' AND "DateField" < date '06/01/2011 00:00:00'

Try this as a Definition query.

Please let me know if that helps!

Re: How do I create a select statement for datepart for a definition query

ShaunHealy1 — Fri, 01 Jul 2016 14:54:13 GMT

Thanks, Katie -

I'm working with something similar to that but can't make the current_timestamp function work. Is that not supported in 10.2.2?

last_edited_date > CURRENT_DATE -7