topic Re: Month in number in App Development

Month in number

OS92 — Fri, 12 Feb 2021 07:58:50 GMT

Hello everyone,

have anybody a solution for my problem?

I need a diagramm with month & year in the form mm/yyyy. As example 02/2021.

In my case, the month is a text and not a number. Is there any function to change the name into a number?

Thanks.

Henri_Rufin — Fri, 12 Feb 2021 20:07:00 GMT

I suggest to create a mapping table you will use then in your model to turn your text into number.

MONTH_MAPPING:

MAPPING LOAD * INLINE
[
MONTH_MAPPING-FROM,MONTH_MAPPING-TO
Jan,1
feb,2
mar,3
...

];

Then apply the following
Subfield(“Field”,’ / ‘,1)&” / “ &ApplyMap(‘MONTH_MAPPING’ , subfield(”Field”, ‘ / ‘ ,2)) as Field

Ksrinivasan — Sat, 13 Feb 2021 09:56:33 GMT

hi,

in dimension

=Num(Month(Dateoo))&'/'&Year(Dateoo)

ksrini

Vegar — Sun, 14 Feb 2021 21:25:39 GMT

If you have a date field then you can create this field by using date() formating function.

Date(monthname(DateField),'MM/YYYY')

With this method you won't get the same issues getting the sorting correct as it will sort chronological and not alphabetical per default.