Search results

  1. M

    Querying a date and time stamped field

    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...
Back
Top Bottom