Separating Date/Time Field

A

admindandr

How do I separate a Date/Time Field in a query, such that
I have two separate field(s) one Date and one Time?
 
J

John Spencer (MVP)

Use the DateValue and TimeValue functions
SELECT DateValue(SomeField) as TheDate,
TimeValue(SomeField) as TheTime
FROM ...

or
CDate(CLng(SomeField)) as TheDate,
CDate(SomeField-CLng(SomeField)) as TheTime

OR ...
 
D

Dave

If your table has the format '16/10/2003 16:34:07' your
query can use

Left(Str([fieldname]),10) for the date and

Right(Str([fieldname]),8) for the time
 
Top