I have a field named "DDate" in my database where default value equal to "=Now()" so it will generate the date and time for new records. I tried to get the sum of record on yesterday. so i wrote: <BR><BR>sqlCount = "select count(subject) as yesterday from table where DDate = (now()-1)" <BR><BR>it returns zero meaning that is no record but it's not. i think the sql is comparing the time too, which is not required in this case... My question is, how can I campare the date without camparing the time in this field? (I need the time for other purpose... so there's no way to change the format into short date) <BR><BR>I hope my question is clear enough, <BR>Please Help!!