Select to view content in your preferred language

Date Values in Filter Expressions

2224
1
09-10-2013 03:11 PM
norie
by
Regular Contributor
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)
0 Kudos
1 Reply
VladislavPlechnoy
Emerging Contributor
Aaron,

Please see SlidingTimeWindowFilterServiceSample.docx attached for details on how to achieve what you are looking for.
Should you require more information please feel free to contact me.

Thanks,
Vlad Plechnoy.
0 Kudos