Date Format Problem

[jason2004]

Hi All,

My first post here and it's got me seriously scratching my head.

I have encountered a problem with the =Date() expression within Access 2003, running Windows XP Professional. The expression returns the current date (in long date format) on my PC, but the same file run on a different PC returns the #Name? error. When I create a new database on the other PC, it returns the date correctly.

I have looked at all the date/region/format settings I can find and cannot spot any difference between the two PCs.

Any guidance greatly appreciated!

Jason

 

[Nero]

Firstly, In the VB Window check you have the same library references selected.
If it still will not work try

 = Format(Now, "dd/mm/yyyy")