I'm writing a query to pick up all records created yesterday. The records are date and time stamped thus:- dd/mm/yyyy hh:mm:ss
Normally if I were trying to retrieve records on a date only stamped field I'd use 'date()-1' in the criteria field to pick up any records created yesterday but when I...