What's wrong with my date?

[Guest]

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

Current_Date_Shortate(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?

 

[Guest]

Please disregard--I've found my solution. Thanks. Ruben

 

[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"

 

[Guest]

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.

 

[xiaaiming]

0000000000000000000000000000000000000
"Jose Ruben Gonzalez-Baird"