hi Otis,

Can you please tell me what will be the predicate expressions for the where clause of query below

select * from tblActivity where DATEADD(mi, -nMinutesToRemind, DtDue) > '6/21/2005 20:00:00'

here, DtDue and nMinutesToRemind both belongs to tblActivity.

Regards Sujay

SQL functions like DateADD aren't supported at the moment.

Sometimes you can work around it, by using normal arithmetic, but you add minutes, so that's not supported. You can try to write your own predicate class, derived from 'Predicate' in the ormsupportclasses, similar to for example FieldCompareValuePredicate.