=Date() no longer works in report in Acc 2010????

[DougP]

Access 2010
I get Error#
I even pasted this and still no go.
=Date(Now())
=Format(Now(),"mmm,dd,yyyy") nada either
only seems to happen on one computer, which is also running Windows 7. the others Pc's are running XP and Access 2003 and Access 2007 where it works fine and was created in Acc 2003 on XP.



DougP
< I Built one

http://www.robots2000.com

 

[Remou]

Check the references in the code window, are any of them marked missing?

http://lessthandot.com

 

[Remou]

(Date(Now()) is not going to work any where)

http://lessthandot.com

 

[DougP]

=Now()
works

DougP
< I Built one

http://www.robots2000.com

 

[Remou]

@DougP The OP mentions that

=Format(Now(),"mmm,dd,yyyy")

Does not work, Date(Now()) was mentioned as desperation, hence the aside.

I suspect a missing reference.

http://lessthandot.com

 

[Remou]

Sorry DougP, I missed that both posts were from you, you should still check the references.

http://lessthandot.com

 

[dhookom]

It gets confusing (and frustrating) when the OP replies but completely ignores a suggestion like your "Check the references in the code window, are any of them marked missing?"


Duane
Hook'D on Access
MS Access MVP