topic Date Values in Filter Expressions in ArcGIS GeoEvent Server Questions https://community.esri.com/t5/arcgis-geoevent-server-questions/date-values-in-filter-expressions/m-p/76125#M346 <HTML><HEAD></HEAD><BODY><SPAN>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. </SPAN><BR /><BR /><SPAN>I tried using the filter below but all events were filtered.</SPAN><BR /><BR /><STRONG>Operand:</STRONG><SPAN> [MyEventDef] [TimeStamp]</SPAN><BR /><STRONG>Operator: </STRONG><SPAN> &gt;</SPAN><BR /><STRONG>Value: </STRONG><SPAN> 01/01/2013</SPAN><BR /><BR /><SPAN>What format would I use to properly filter a date field?</SPAN><BR /><BR /><BR /><SPAN>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 &gt; DateTime.Now().AddDays(-3)</SPAN></BODY></HTML> Tue, 10 Sep 2013 22:11:35 GMT norie 2013-09-10T22:11:35Z Date Values in Filter Expressions https://community.esri.com/t5/arcgis-geoevent-server-questions/date-values-in-filter-expressions/m-p/76125#M346 <HTML><HEAD></HEAD><BODY><SPAN>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. </SPAN><BR /><BR /><SPAN>I tried using the filter below but all events were filtered.</SPAN><BR /><BR /><STRONG>Operand:</STRONG><SPAN> [MyEventDef] [TimeStamp]</SPAN><BR /><STRONG>Operator: </STRONG><SPAN> &gt;</SPAN><BR /><STRONG>Value: </STRONG><SPAN> 01/01/2013</SPAN><BR /><BR /><SPAN>What format would I use to properly filter a date field?</SPAN><BR /><BR /><BR /><SPAN>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 &gt; DateTime.Now().AddDays(-3)</SPAN></BODY></HTML> Tue, 10 Sep 2013 22:11:35 GMT https://community.esri.com/t5/arcgis-geoevent-server-questions/date-values-in-filter-expressions/m-p/76125#M346 norie 2013-09-10T22:11:35Z Re: Date Values in Filter Expressions https://community.esri.com/t5/arcgis-geoevent-server-questions/date-values-in-filter-expressions/m-p/76126#M347 <HTML><HEAD></HEAD><BODY><SPAN>Aaron,</SPAN><BR /><BR /><SPAN>Please see SlidingTimeWindowFilterServiceSample.docx attached for details on how to achieve what you are looking for.</SPAN><BR /><SPAN>Should you require more information please feel free to contact me.</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><SPAN>Vlad Plechnoy.</SPAN></BODY></HTML> Wed, 11 Sep 2013 19:41:35 GMT https://community.esri.com/t5/arcgis-geoevent-server-questions/date-values-in-filter-expressions/m-p/76126#M347 VladislavPlechnoy 2013-09-11T19:41:35Z