Problem with timestamp query

[Brlee1crv]

Greetings,
I have a field on a form (ReviewStamp) that is timestamped Date() if Completed is selected in a combo box. However when I try to query for records using this field in the table, I get no results. I've tried creating a query using Date() for the criteria under the ReviewStamp field and tried using a date range query but to no avail. Does the time have anything to do with the query not working? Help. Thanks.

 

[Blorf]

It can. If you are putting a full date and time in a record, then using Date() won't be specific enough.

If thats the case, then instead of using date() for criteria, try using >=date() and <=date()+1. This makes it possible to get data for the next day, but only if it is the next day at exactly midnight, so probably OK.

ChaZ

 

[Brlee1crv]

That's what I'm afraid of...is there a way of timestamping a field with just the date only?

 

[Blorf]

Well, using just date() gives you just the date, no time. Is that what you are using? Or are you using now()?

ChaZ

 

[PHV]

What are the real values of ReviewStamp in the table ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Brlee1crv]

Thanks Blorf...whoops I realized I typed the wrong thing. I am using Now() and not Date(). I tried using date() but everytime I used it on the form Access would enter the date that the record was created and not when Completed is selected in the combobox.