RE: Date/Time to Numeric Date

, 1900 for smalldatetime. Different DB;s use different reference dates. eg. I think Pick Universe u ses 31 Dec 1967. try this one in CF: #datediff("d", "1/1/1900", "1/1/2002")# cheers andy > -Original Message- > From: Vinny DiDonato (si.rr) [mailto:[EMAIL PROT

Date/Time to Numeric Date

Hi Folks: Hopefully this isn't a stupid question, so here goes: Our Spectra DB stores dates/times in a numeric format such as 37195.0. Converting this value to a date/time string which makes sense has been accomplished, but my question is this: How does the date/time get converted into