Search results

Thabks for the reply but I've misled you a little, the field is just a date / time field as dd/mm/yyyy hh:mm:ss. Will the above solution work?

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...