invalid column name 'Date' error message

alicejwz · #1 (**permalink**) 01-30-03, 08:17

I created a text box and set the control source property =Date() to display today's date on a report. An error message appeared "invalid column name 'Date'. Why am I getting this message?

Thanks!!

FirstAndGoal4 · #2 (**permalink**) 01-30-03, 10:36

Quote:

Originally posted by alicejwz
I created a text box and set the control source property =Date() to display today's date on a report. An error message appeared "invalid column name 'Date'. Why am I getting this message?

Thanks!!

Did you try =Date without the ()?

alicejwz · #3 (**permalink**) 01-30-03, 11:58

Quote:

Originally posted by FirstAndGoal4
Did you try =Date without the ()?

It still gave me the same error message. I created another report and place/call the date function in the property of a text box and it works. Something weird is going on.

FirstAndGoal4 · #4 (**permalink**) 01-30-03, 12:00

Quote:

Originally posted by alicejwz
It still gave me the same error message. I created another report and place/call the date function in the property of a text box and it works. Something weird is going on.

How about =Now()

alicejwz · #5 (**permalink**) 01-31-03, 08:02

Quote:

Originally posted by FirstAndGoal4
How about =Now()

Yes, it does work with Now(). Why is that?

Internet Services

Web Development

Digital Marketing

Consumer Tech