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#)
 
G

Guest

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

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

Date Conversion- DATEVALUE- including minutes 3
Incorrect Date function 6
Convert Integer to Date in Access ADP Project 2
Date issue 9
Is there a Date Time Conversion from text? 2
Date axes in Excel 2003 and 2007 5
Convert Access SQL Query to Excel MS Query 1
Excel PRICE function: How does it compute Issue Date of the Security 5

Top