I've got a table that I need to store date and time in form of "3/1/2011 10:41:36 AM". I know that I can select this through SQL with "format([date], 'mm/dd/yy'". However how can I run criteria against these formated dates? Where date()-1 and so fourth. I cannot get any results.