Date

  • Thread starter Thread starter Fushiren
  • Start date Start date
F

Fushiren

Guest
Hi all,

I have designed in my report a date field which will show the short date of the day that the report is generated or printed (Not when the record was entered).

My MS access' database file is stored on a server and is shared through a network by other computers. But for some reason, one computer on the network when generating the report will show in the date field "#name?" while the rest of the computers on the network all displays the current date.

The code I have entered in the date field is

=Format(Date(), "Short Date")

Can somebody give me some advise and assistance?
Thanks in advance!
 
I've had this problem with certain PC's before.

Try using

=DateValue(Now())
 
Hey Saintman,

You suggestion fixed the problem...would u mind sharing how ur solution worked and what was the problem I experienced before with dates?

Thanks a million!!
 
Fushiren,

I found the solution so long ago I can't remember how I found it. The problem occured after we bought new PCs with higher spec processors. It worked on the old machines but not the new and I could never get an answer from our IT gurus (not that they ever knew anything about Access anyway). As I always use the alternative I never have the problem anymore so I don't know whether it still is a problem on the even higher spec PCs we have now.

Glad it helped.
 

Users who are viewing this thread

Back
Top Bottom