Using the DAL, I'd like to select records that are less than some interval old, or newer than a certain date. My records have a datetime field in them.
So I want something like: select * from table where mydate > (now()-interval 1 day) Can I do this in the dal, or do I have to use raw sql? Thanks, Ed