Date() Function on Network

[mtwildtrout]

I'm having a problem with the Date() function not working when I install my Access application on a network. The Date function is used as a default value on my sign-on form. It works perfectly when I install the front and back end applications on a single computer. When they are installed on a network, I get #Name in the date field instead of today's date. Does anyone have any ideas why this is happening?

 

[Rolliee]

I have haqd similar experience and now only use now() for the time and date and int(now()) for simple date.

rollie@bwsys.net

 

[mtwildtrout]

Thanks Rolliee, that did the trick!