Using the Date() function as criteria for a query but when running the query the system responds with "Undefined Function 'Date' in expression".
I have another database on the same PC where it does work. Strange.
Any suggestions? tks!
Using the Date() function as criteria for a query but when running the query the system responds with "Undefined Function 'Date' in expression".
I have another database on the same PC where it does work. Strange.
Any suggestions? tks!
you can also use format(now(), "Short Date") where "Short Date" is the name of any date format you want.
I would strongly recommend fixing the source of the problem, not working around it. If it's a reference problem, other functions will do the same thing.
And if it isn't a reference problem, there are a couple of other possible options:
1. Try a decompile. See here for how: http://www.granite.ab.ca/access/decompile.htm
2. It sometimes is because of a field or object named Date ever existed in the database. If it doesn't exist there anymore, importing to a new database shell will sometimes cure it. If it does exist, then rename (making sure name autocorrect is turned off before doing the rename).