Full Version: Problem in extracting the date portion out of the following
UtterAccess Forums > Microsoft® Access > Access Forms
gamaz
Hi,
I have a table where the RequestDate is given as : 3/23/2009 5:45:02 PM
When I doing a query on the RequestDate e.g. #3/23/09# and #3/35/09# it is not giving me any values. How can I change the query so that the time part is left out and a query is done on the date portion. I appreciate any help. Thanks.
Jack Cowley
In the top line of a column in your query - ReqDate: Left([RequestiDate],InStr([RequestDate]," "))
th,
Jack
gamaz
Thanks Jack. This works perfect.
Jack Cowley
You are most welcome and continued success with your project....
ack
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.