Format date issue

[teel73]

I'm trying to run a simple query (MS Access 2007) where I need to format the date column to a short date.

My expression is returning an error "Undefined function 'Format' in expression". I don't understand the issue since this is how I've always done it in Access vs 2003. Has the syntax changed? Below is the expression I have in my query grid.

Expr1: Format([CREATE_DATE],"mm/dd/yyyy")

 

[boblarson]

That usually means that you have something somewhere which is conflicting with it. Do you have a field or object in your database named format? Also, go into the VBA window and go to DEBUG > COMPILE and compile your app. It may give you an error and then take you to it to fix it.

Or, if you have upgraded your database from the 2000, or 2002-2003 format to 2007 by doing the SAVE DATABASE AS, I would suggest creating a new database file and then

IMPORT all of your objects in and reset any start up options, etc. The upgrade would work much better that way.