get numerical representation of month from month() - Qlik Community

Report Inappropriate Content · ‎2015-01-22

month( '1971-10-30' ) returns Oct

How do I get 10 which represents October.

jonathandienst · ‎2015-01-22

Hi

Use Num(month( '1971-10-30' )), or if it is in a table, set the format to integer.

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

Report Inappropriate Content · ‎2015-01-22

When you use the month function, the underlying result is a dual, so has the text representation of 'Oct', if you adjust the format for your field to number, this will display 10.

or you can wrap num around it, if required in the script.

Num(month( '1971-10-30' ))

hope that helps

Joe

Report Inappropriate Content · ‎2015-01-22

Use Num(month( '1971-10-30' ))

- Lalit