=Date() Not working - help ?

G

Guest

In DB 1, I have a Menu Form with a field to show today's date. ( =Date().)
It used to work. It works on everyone else's machines. On my mahcine it now
comes up as #Name?

If I open DB2 (on my same pc), the exact same form DOES show the =Date()
field correctly as today's date.

I imported the form from DB2 into DB1. Just won;t work in DB1, continues to
come up with #Name?

When I run a query referencing this field (show me records with today's
date), the query requests user input for 'Format' and then 'Date'. I DO
appear get the correct record just entering '*' against the input request.

Help - any ideas please ?
 
G

Guest

Thanks Allen - the library does indeed say 'missing'. Haven;t had a go at
fixing it yet - because I don;t know enough. But, this should help our tech
help me. Many thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top