Both M/c have same setting for long date & short in regional settings. I just checked it.
To continue with it most function seems to give problem. I am also using Left$ , Right$, Format and all give problem.
Yet on another database on same m/c it works fine.
If I apply the mask thru format...
One of the Query is formatting date in this way
Format([EFF DATE],"mm/dd/yyyy") AS Effdate
For the same database a person in one location can run the query correctly but another person in another location gets #Error in that column. Can any body suggest any solution.
Format function...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.