3 Replies Latest reply: Feb 19, 2013 9:02 AM by 798480 RSS

    Problem with Coherence*Extend LessEqualsFilter and DateTime

    717268
      I have a cache with the following DataTime field

      Date
      ================
      07/07/2010 12:13:57:977000
      07/07/2010 12:13:58:528000
      07/07/2010 12:13:59:055000
      07/07/2010 12:13:59:575000
      07/07/2010 12:14:00:117000
      07/07/2010 12:14:01:289000
      07/07/2010 12:14:02:465000
      07/07/2010 12:14:02:570000
      07/07/2010 12:14:03:684000
      07/07/2010 12:14:03:774000
      07/07/2010 12:14:05:903000
      07/07/2010 12:14:06:024000 <-----
      07/07/2010 12:14:07:012000
      07/07/2010 12:14:07:117000
      07/07/2010 12:14:08:168000
      07/07/2010 12:14:08:274000
      07/07/2010 12:14:09:231000
      07/07/2010 12:14:09:320000
      07/07/2010 12:14:10:262000
      07/07/2010 12:14:11:325000
      07/07/2010 12:14:11:508000
      07/07/2010 12:14:12:555000

      Using .Net Coherence*Extend

      If I filter entries for Date <= 07/07/2010 12:14:06:50000 i.e. new LessEqualsFilter(“Date”, new DateTime( 2010, 07, 07, 12, 14, 06, 50 ))

      The market record (<----) record is not being retuened.

      It seems to me the comparison ignores the milliseconds.