ArcGIS query layer for date

Discussion created by brightbluesky on Dec 20, 2012

I am current trying to do layer definitions on a map and so I am trying to filter some records via a time factor so i was writing in the Where field DATE_CLOSED_ON > (CURRENT_TIME - 24) and DATE_CLOSED_ON is not NULL.

I believe that in order to query a date field there is a must to include the field is not null. As for the time factor I am trying to query records that are closed less than 24 hours ago but the query keep returning me all records with a non null DATE_CLOSED_ON field.