B BL Mar 2, 2004 #1 Is there a function in Access that allows you to convert a date text January 1, 2008 to its serial number 39448?
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 Mar 2, 2004 #2 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#)
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#)
G Guest Mar 2, 2004 #3 Thanks, I should have thought of the datedif myself as I have been staring at it all day.
