Retrieve Month from text - Page 2 - Qlik Community

Report Inappropriate Content · ‎2016-01-19

Good evening,

I I have to retrieve month from text column . The column is labelled

'ValueJan'

'ValueFeb'

'ValueMar'

..

...

..

and soo on.

How I can correctly retrieve the month ?

MarcoWedel · ‎2016-01-20

You might also have to set your LongMonthNames variable to your local month names to make the Date#( ... ,'MMMM') approach work.

regards

Marco

MarcoWedel · ‎2016-01-20

another one:

Subfield(YourField, 'Value', 2)

regards

Marco