Date and Time

J

Jay

Table has a field with Date/Time data type ( 09/08/2005 21:45:35 format).
I need to separate its Date and Time portions into two fields (Date Field
and Time Field). How Can I do that? Later I need to combine them again. How
Can I?
Use function or another query? Thank you. Really appreciate your help.
 
D

Duane Hookom

Use DateValue() to get the date portion of the value and TimeValue() to get
only the time portion.
 
Top