I'm trying to change the month language when I produce a query so that when the data from the query is shown in a report the language of the date is shown correctly.
A report is shown in English and the date is 1 January 2011
When the report is for a Spanish client I want 1 enero 2011
I have the following code but it says I have a syntax error, plus not sure if I am barking up the wrong tree and should do this a different way anyhow.
Ian
A report is shown in English and the date is 1 January 2011
When the report is for a Spanish client I want 1 enero 2011
I have the following code but it says I have a syntax error, plus not sure if I am barking up the wrong tree and should do this a different way anyhow.
Code:
test: Select Day ([Arrival Date]) & " " & Choose(Month([Arrival Date]), "Enero", "Febero", "Marzo") & " " & Year([Arrival Date]) As FormattedDate;
Ian
Last edited: