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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert date serial from text to date value 4
How do I convert a database "serial format date" to a calendar dat 1
Convert date to serial number 12
Flat File Problems 2
Concatenate 6
AutoNumber based on Model, Serial & Date 7
Merge Tables? 7
Formula for converting xx/xx/xxxx dates to a number between 1 and 2

Top