By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,302 Members | 1,716 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,302 IT Pros & Developers. It's quick & easy.

How to show today's date on Report?

P: 111
I have a report on which I want to show today's date. The first option I tried was to put a textbox and write =Date() as a control source property. (my form is bound so it was forcing me to select something from dropdown , although I overtyped that function)
second option I tried to do it from Insert menu.
Both the times I am getting this error.
"The function you entered can't be used in this expression"
You may have used a doevents blabla
You may have used an aggregate function, such as count....bla bla
Can anybody tell why is it doing this?

Jul 21 '09 #1
Share this Question
Share on Google+
4 Replies

Expert 100+
P: 1,287
=Date() is perfectly fine as a control source property. Something else is causing the error. Make sure the report works without the text box, then recreate it and make sure it is unbound. Maybe also check that you aren't using something else named Date.
Jul 21 '09 #2

P: 111
Report runs without the textbox perfectly fine. Is there any & sign required?
I mean something like = & Date () & anything like this? If so, what is the correct sign?
I can't think of any other thing. Can you give me hint on what that "Something else" is causing the error?
Jul 21 '09 #3

Expert 100+
P: 1,287
Does the Date() function work for you elsewhere? The only other indication I could find of why this would cause an error would be a problem with DAO references.
Jul 21 '09 #4

Expert 100+
P: 266
Also just for the sake of argument, could you try "= Now()"? I know that "=Date()" has given me a problem or 2 before, but i never could figure out why. Could be nothing.

Jul 22 '09 #5

Post your reply

Sign in to post your reply or Sign up for a free account.