Date Values in Filter Expressions

Discussion created by aaronnoriega on Sep 10, 2013
Latest reply on Sep 11, 2013 by vplechnoy-esristaff
My service is processing events containing a TimeStamp (Date type) field. When the device sending data to GEP boots, it sends some bad records with a timestamp occuring in 1999.

I tried using the filter below but all events were filtered.

Operand: [MyEventDef] [TimeStamp]
Operator: >
Value: 01/01/2013

What format would I use to properly filter a date field?

Ideally, I would like to use a sliding value for the filter. Is there way to calculate a dynamic value for a filter? Something akin to Timestamp > DateTime.Now().AddDays(-3)