Discussion board where members can get started with QlikView.
in the Help section the description of the Month() function says as follows:
Month. Returns a text string representing the month when the fraction of expr is interpreted as a date, but can be formatted as a number.
Example:month( '1971-10-30' ) returns Oct.
(Worth noting that the functions Year() and Day() return integer and not text)
However, in the Edit Script section, when building a calendar and using the Month() function it returns an integer 1, 2, 3, ...
Why is the difference and how can I get the numerical value of the Month(Today()) or Month(Now())?
Write your formula like the following:
This will return the numerical version of the month.
View solution in original post
That did the trick!