` Printed Icetips Article

Icetips Article



Par2: Converting VB dates
2002-05-30 -- Randy Rogers
 
vb returns date/time as 8 byte float (real)
integer portion is date and decimal portion is time
negative values are dates prior to dec 30, 1899

for positive values:
int(vbDate) + 36161 = cwDate

and the time would be calculated as
cwTime = (vbDate - int(vbDate))* 8640000

**note a 1 might have to be added ... i'm not sure



Printed November 21, 2024, 11:16 am
This article has been viewed/printed 35216 times.