Serial Date

S

Sash

I need to convert a date field into the serial date. For example, I watn
12/2/2008, to become 39784. Any ideas?
 
J

John W. Vinson

I need to convert a date field into the serial date. For example, I watn
12/2/2008, to become 39784. Any ideas?
Click to expand...

CLng([datefield]) will do the trick.
 
F

fredg

I need to convert a date field into the serial date. For example, I watn
12/2/2008, to become 39784. Any ideas?
Click to expand...

What is a serial date?
You seem to want to convert a date to it's numerical value.

? Clng(#12/2/2008#)
39784

To go the other way, use:
?CDate(39784)
12/2/2008

Please note that no matter how you display the value, if it is a Date
datatype field Access will store the value as 39784.0, so perhaps you
really don't need to do anything.
 

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

How to convert serial date&time to normal date&time? 2
Windows 7 I need to convert date to text 3
Unique Counting With Multiple Criteria 8
Access Macro Repeat Expression using value of a field in table 0
Date problem 2
cross referencing two worksheets 2
How to get a signal from the Task Scheduler 3
Convert Excel Serial Date to Date 1

Top