Datepart and Dateadd errors Access 2007

  • Thread starter Thread starter Date Functions format errors
  • Start date Start date
D

Date Functions format errors

I continually get an error message when I use the datepart and dateadd
functions.

The following command produces and error datepart("m", now()).

What I'm I doing wrong?
 
It works like a champ for me. What is the error message? That tidbit would
help us to help you.

Does the following work?

Debug.Print DatePart("m", #1/1/2009#)

If not, something is wrong with DatePart. If it does work, something could
be wrong with the Now() function.

Both problems could be with references. Go to the following web page for
information on checking references:

http://www.mvps.org/access/bugs/bugs0001.htm
 
.... and the error message says ... ?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Date Functions format errors" <Date Functions format
(e-mail address removed)> wrote in message
news:[email protected]...
 
Back
Top