EZWriter Dates in Another Language

If you create EZWriter pages or Word Merge documents in multiple languages, you may want to have spelled out date names such as "September" or "Tuesday" display in the same language that the rest of the document is in.  

To create an EZWriter data source in a different language than the default of your database, you only have to add one extra line to the top of the data source:

SET LANGUAGE  [Language Name] 

Where the value between the square brackets is the name of the language.  This name can either be the native language name (e.g. Deutsch) or an alias (e.g. German).  For the full list of languages supported, please visit http://technet.microsoft.com/en-us/library/ms190303.aspx.

After using set language, all date names as well as many error messages will be the selected language for the remainder of the SELECT statement.  This means that to support multiple languages, you will have to create one EZWriter data source for each language.