Good day,
I'm building a dashboard which needs to be in English, French and Portuguese.
What I'm looking for is to be able to have the correct MonthName for the language in a text box.
I.E:UPPER(DATE(TODAY()-1,'DD MMM YYYY')) returns 28 MAY 2017 perfectly for English, however I would need to have the month name displayed as for mai French or maio for Portuguese.
I have a list box in the document to change a variable vLanguage between EN, FR and PT. and have a load inline statement to link the various months and with DATE on master calendar.
MASTERCALENDAR: LOAD
DATE(DATE) AS DATE
,DAY(DATE) AS DAY
,WEEKDAY(DATE) AS WEEKDAY
,NUM(WEEKDAY(DATE)) AS WEEKDAYNUM
,WEEK(DATE) AS WEEK
,NUM(MONTH(DATE)) AS MONTH
,WEEK(DATE) &'-'& NUM(WEEKDAY(DATE)) AS [WEEK-DAY]
,DAYNUMBEROFYEAR(DATE) AS [DAYNUMBER]
,'Q' & CEIL(MONTH(DATE) / 3) AS QUARTER
,YEAR(DATE) AS YEAR;
LOAD DATE(MIN + ITERNO()) AS DATE ,MAX WHILE MIN + ITERNO() <= MAX;
LOAD MIN(FIELDVALUE('DATE', RECNO()))-1 AS MIN, MAX(FIELDVALUE('DATE', RECNO())) AS MAX AUTOGENERATE FIELDVALUECOUNT('DATE');
LOAD *
INLINE [
MONTH,vLanguage,MonthName,Language
1,FR,janv,French
2,FR,févr,French
3,FR,mars,French
4,FR,avril,French
5,FR,mai,French
6,FR,juin,French
7,FR,juil,French
8,FR,août,French
9,FR,sept,French
10,FR,oct,French
11,FR,nov,French
12,FR,déc,French
1,EN,Jan,English
2,EN,Feb,English
3,EN,Mar,English
4,EN,Apr,English
5,EN,May,English
6,EN,Jun,English
7,EN,Jul,English
8,EN,Aug,English
9,EN,Sep,English
10,EN,Oct,English
11,EN,Nov,English
12,EN,Dec,English
1,PT,jan,Portuguese
2,PT,fev,Portuguese
3,PT,março,Portuguese
4,PT,abril,Portuguese
5,PT,maio,Portuguese
6,PT,junho,Portuguese
7,PT,julho,Portuguese
8,PT,agosto,Portuguese
9,PT,set,Portuguese
10,PT,out,Portuguese
11,PT,nov,Portuguese
12,PT,dez,Portuguese
];
But I need a way to have the correct Month name shown when the vLanguage is changed. Any ideas?
