BI Publisher - Date in footer not showing as intended
We have a RTF Template in which we need to insert a date in the footer with the following format and in spanish: <DAY_OF_THE_WEEK>,<DAY> <MONTH> <YEAR>.
The problem arises when we publish the report, either using the MS Word BI Publisher plug-in, or either directly in the server.
The date in the footer is presented incorrectly and in the wrong language (in our case is in portuguese when it should be in spanish as we mentioned before). For example, today's date (28-10-2020) is showing like: "dddd 28 Outubro 2020" when it should be like "miércoles 28 octubre 2020". In the template the date is presented correctly and in spanish, but when we publish the report, the mask regarding the day of the week isn't replaced with the corresponding information and the date is presented in the incorrect language.