This discussion is archived
3 Replies Latest reply: Feb 19, 2013 7:02 AM by 798480 RSS

Problem with Coherence*Extend LessEqualsFilter and DateTime

717268 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points