Serial Date

  • Thread starter Thread starter Sash
  • Start date Start 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?
 
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

Unique Counting With Multiple Criteria 8
How to convert serial date&time to normal date&time? 2
Date problem 2
How to convert or transpose variable list into table 0
Windows 7 I need to convert date to text 3
Access Macro Repeat Expression using value of a field in table 0
Some more about serialization 3
Find "Last Friday" function works almost 100% 10

Back
Top