Datetime to date & time & back

[John]

Hi

I am using and access datetime field to store both date & time. How can I
split it into date & time after reading the field and then combine the date
& time back into datetime when storing it?

Thanks

Regards

 

[Mary Chipman]

Working with datetime always gives one fits when one needs either the
date, the time, but not both. Access stores datetime values internally
as a double, with the date to the left and the time to the right of
the decimal, which you can see if you use a conversion function on
datetime. Often developers find it helpful not to store time values in
datetime, but as integers. The approach you take depends on what you
need to do with the values.

--Mary