Hi, I have a problem with the DateTime field. In database, let say I defined a table with 2 fields a PK and a DOB (datetime) field. Later on, I want to do a search to see how many records have a match of DOB.month = 4. The problem is that I can't chop the datetime field into 3 smaller fields for dd, MM, and yyyy as it is part of the DB design.
I know I can do it easily with a stored proc, but after I read Frans' blog about this SP, I think I 'd try using DQE first, and here I dont know how to do it using DQE. If any body knows, please let me know. Thank you.

At the moment there is no expression predicate, so you can only compare the field. If you want all records in 1 year with month=4 you can try a between predicate.