Serial Date

[Sash]

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

 

[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?

CLng([datefield]) will do the trick.

 

[fredg]

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

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.