Convert date to serial number format

S

Sherry

I know you can convert a date in Excel to its serial
number, but can you do the same thing in Access? And how?

Thanks,
Sherry
 
A

Allen Browne

Try:
CDbl(Date())

Careful though: date/time is not actually the same as a floating point
number. It behaves very differently for negative values (before 1900).
 
Top