Hi,

How can I have a predicate which says - select where date is in the month of January?

Cheers,

Ian.

Either: 1) add a calculated column to your table, and filter on that column or 2) create a special IPredicate implementation, by copying the FieldCompareFieldPredicate class sourcecode and modifying it into FieldCompareMonthPredicate.

Why wouldn't a between work?

DateTime startDate = new DateTime(2005,0, 1);
DateTime endDate = startDate.AddMonths(1).AddSeconds(-1);

IRelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.PredicateExpression.Add( PredicateFactory.Between(FooFieldIndex.TimeStamp, startDate, endDate) );

Cadmium wrote:

Why wouldn't a between work?

DateTime startDate = new DateTime(2005,0, 1);
DateTime endDate = startDate.AddMonths(1).AddSeconds(-1);

IRelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.PredicateExpression.Add( PredicateFactory.Between(FooFieldIndex.TimeStamp, startDate, endDate) );

I thought of that, but it might be he wants to have all values of all the years If not, a between will work indeed!

I suppose I could add a between for all years within a 200 year span.

In fact, a 'for' loop for the next 5 years would probably suffice. That would give me enough time to get round to creating a custom IPredicate.

Otis wrote:

I thought of that, but it might be he wants to have all values of all the years If not, a between will work indeed!

Oh, I see now. Right, yeah that would be a bit more difficult