Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi Chris,
How about this?
=Date(Today(), 'DD ') &
Only({<MONTH = {$(=Date(Today(),'M'))}>}MonthName) &
Date(Today(), ' YYYY')
Hi Chris,
Please check attached file.
Regards
Miguel del Valle
Hi Miguel,
I've added a text box which is what I'm looking to have the dynamic change when the language is changed.
Do you have any ideas on that?
Hi Chris,
How about this?
=Date(Today(), 'DD ') &
Only({<MONTH = {$(=Date(Today(),'M'))}>}MonthName) &
Date(Today(), ' YYYY')
Thanks Ronald - that's the solution
Almost there - works for the majority of cases. I now need to get FirstSortedValue(RELEASENUMBER, -DATECREATED) to ingore a field called product - any ideas on that one?