I have used the Date() function MANY times in the db’s I write. I am now finding that some of the users get the system date returned and some get the #Name? error. If I try to add a new field using Date() I get this error:
The function you entered can’t be used in this expression.
*You may have used a DoEvents, LBound, UBound, Spc, or Tab Function in an expression.
*You may have used an SQL aggregate function, such as count, in a design grid or in a calculated control or field.
I amobviously not doing any of those things to get the error. Nothing on TechNet or MS website is finding anything. Why will it work on some pc’s and not others? I haven’t been able to find a connection.
