I have letters that need to go out in either English or Spanish. While the rest of the Spanish letter is in Spanish, the date, (=Now()) in the footer, is in English. Is there a way to get =Now() to print in Spanish?
I have letters that need to go out in either English or Spanish. While the rest of the Spanish letter is in Spanish, the date, (=Now()) in the footer, is in English. Is there a way to get =Now() to print in Spanish?
Try Googling Spanish to English =ahora()
HTH
I dont need a translation, I need to know if MS Office has the Spanish equivilent of "=Now()" for use in headers or footers in MS Office 2010 (English version)? Oh, and this is not Dave.
As far as I know, the Spanish translation for "=Now()" is "=Now()". I have seen some IDE's that convert VB6, etc to languages other than English. Don't know if anything like that is available for VBA. Maybe you can search for a "Spanish IDE add in for Access".
As for "=Now()" appearing in the footer, I do not know what that means.
=Now() generates a date in the form of "Friday, May 2, 2014" in headers and footers of reports for Access, Excel and Word and I'm sure in the other Office products as well.
=Now() is an expression that Access will evaluate and return:
5/2/2014 11:58:42 AM
How would that be different in Spanish?
=Format(Now(),"Long Date") will return:
Friday, May 02, 2014
If you want that to return in Spanish then maybe need to select Spanish as the language setting for db in Options.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.