What's wrong with my date?

  • Thread starter Jose Ruben Gonzalez-Baird
  • Start date
J

Jose Ruben Gonzalez-Baird

I tried created a custom formatted date in my Acces query:

Current_Date_Short:Date(m/d/yyyy)

But an error meesage reads that there are the wrong number of arguments. I
tried playing around with using quotes also but to no avail. What's my
problem?
 
J

Jeff Boyce

Other folks may run into the same situation that originally puzzled you.
Consider posting the solution you found to help others out if they search
for and find your original post.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Jose Ruben Gonzalez-Baird"
 
J

Jose Ruben Gonzalez-Baird

That's a great idea!

Here is the solution I found:

Current_Date_Short: Format([Current Date],"m/d/yyyy")

I found that I could re-format an existing date field in my query. NOTE, the
comma after the field name [Current Date] is important.

m returns either a 1 or 2 digit month number as needed
d returns either a 1 or 2 digit day number as needed
yyyy returns a four-digit year.
 
Top