Excel DateValue Function in Access

B

BL

Is there a function in Access that allows you to convert a
date text January 1, 2008 to its serial number 39448?
 
D

Douglas J. Steele

Just format it as a number.

?Format(#01/01/2008#, "0")
39448

Alternatively, since day 0 is 30 Dec, 1899, you could do use DateDiff("d",
#12/30/1899#, #01/01/2008#)
 
B

BL

Thanks, I should have thought of the datedif myself as I have been staring at it all day.
 
Top