I have an access database that I have inherited and looking for a little help. I have a simple select statement where I need to pull only the records from yesterday. The only problem is that the only date field that should be a date / time field is text.... So what I tried in the select in a new column was cdate(datefield)..Which appears to be working. My hopes were to then put in the criteria Now()-1 But this returns 0 records, even though there are records from yesterday I tried the same scenario with the same results using the date() -1 in the criteria. Is it possible to do this type of select with a CDATE field, or is there a better way to do this.
source datefield format is dd-mm-yyyy (01-10-2008) October 1, 2008