Format current date

[Guest]

Is there anything wrong with this script. I'm using it in a query.

CDate: Format(Date(),"mmmyy")

I keep getting the following error msg.

Error msg: Wrong number of arguments.

Thanks

 

[Rick B]

I believe that "CDATE" is the name of a function that is available in
Access. My guess is that you are confusing Access by using "CDATE" as a
field name.

 

[Terry Kreft]

CDate is a VBA reserved word.

Change it to something like;-

CaDate: Format(Date(),"mmmyy")