Merging two date/time fields

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

I have a date/time field which contains date and another one which contains
time. How can I merge the two into a single date/time field?

Thanks

Regards
 
Add them together. In Access, date/times are stored as 8 byte floating point
numbers, where the integer part represents the number of days relative to 30
Dec, 1899, and the decimal part represents the time as a fraction of a day.
 
Back
Top