DATE TIME seperator

S

sjb11

Joined
Jun 16, 2007
Messages
6
Reaction score
0
In a query, I am looking at a table whereby it is stored as DD/MM/YYYY HH:MM:SS. I am trying to only use the date part and ignore the time. What is the build function text/string I need to use? Its Access 97 that Im using.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query to Update Date 2
Date Function in query 3
Date/time query 1
Select time only from a date/time field 8
Seperating a Timestamp 4
Formatting date gives bad results in query 2
Query to get information that doesn't match by date 2
Date Calculation 1

Top