date() function issue

hi...

have got an access database set up and i'm using the =date() function to
apply date to a box.
problem is if anyone else tries to use this (on another physical PC) they
get an error.
=now() works ok but gives time etc which we dont want.
would the =today() function be a better bet?

cheers

billyw wrote:
hi...

have got an access database set up and i'm using the =date() function
to apply date to a box.
problem is if anyone else tries to use this (on another physical PC)
they get an error.
=now() works ok but gives time etc which we dont want.
would the =today() function be a better bet?

cheers

This is going to sound strange, but compare the Regional settings in the
control panel of a machine that works and one that does not.

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math

More than likely you have a missing reference on the machine(s) which
exhibit the problem. To check is easy enough:

On the affected machines open any code window or press Ctrl+G.

Go to Tools ... References

and either uncheck, or find and fix any marked as MISSING

It doesn't even matter which library is affected, as a single missing
reference can affect the entire application. For further information, Allen
Browne has this great information.

Http://members.iinet.net.au/~allenbrowne/ser-38.html

and Doug Steele has this:

http://members.rogers.com/douglas.j....nceErrors.html
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

"billyw" wrote in message
...
hi...

have got an access database set up and i'm using the =date() function to
apply date to a box.
problem is if anyone else tries to use this (on another physical PC) they
get an error.
=now() works ok but gives time etc which we dont want.
would the =today() function be a better bet?

cheers

"billyw" ëúá
...
hi...

have got an access database set up and i'm using the =date() function to
apply date to a box.
problem is if anyone else tries to use this (on another physical PC) they
get an error.
=now() works ok but gives time etc which we dont want.
would the =today() function be a better bet?

cheers