date time

  • Thread starter Thread starter ram.sasha
  • Start date Start date
R

ram.sasha

I have 2 numeric variables date (09/21/1999 )and time ( 7.52) in this
format . How do I merge both these variables and get datetime in
datetime20. format?

Thanks
 
Add them together. Internally, dates are stored as 8 byte floating point
numbers, where the integer portion represents the date as the number of days
relative to 30 Dec, 1899, and the decimal portion represents the time as a
fraction of a day.

(I'm assuming, of course, that your variables are both Date types. If
they're String, you'll need to use the CDate function on the strings).

Any reason for two separate values?
 
Back
Top