Inserting Today's Date in a Report

[smdemo]

I've taken someone else's database and I'm trying to enter the date in the report and its giving me an error.

I created a text box with the following entered in the Control Source...

=Format(Date(),"mmmm d"", ""yyyy")

When I go to run the report it asks me to enter a "Format" and then a "Date".

I've tried it on other reports of databases I have created and it works fine. Any ideas?

 

[rjoubert]

Try this...

=Format(Date(),"mmmm d, yyyy")

 

[smdemo]

Opps, I'm not sure how those extra quotes got in there on my post. I do have what you suggested and its not working. Its also telling me that I have entered invalid syntax when I try to save it and that I might have an invalid comma or ommitted quotation marks. I know that's not the case since the same control source works on all my other databases.

 

[rjoubert]

the same control source works on all my other databases

Are these other databases on the same PC? If they are on different PCs, there may be an issue with missing DLLs, or perhaps a difference in the version of Access between PCs.

 

[mauricionava]

Try Now() instead of Date(), some computers do not have a file int the microsoft office program files folder and the Date() function does not work well.

I had this problem before and tried the Now() funtion and works well in all computers.

 

[GingerR]

Probably a problem with your references

faq181-936

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[smdemo]

Thank you rjoubert, you are right. The database was created using a newer version than I have. They converted down to the version I am running. I'll never understand why companies use different versions in different departments.

Thanks again.