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

[ShaunHealy1]

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.

[Anonymous User]

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!

[ShaunHealy1]

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