Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Question regarding Month() Function

Hi all

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())?

Thanks

1 Solution

Accepted Solutions
Highlighted
Not applicable

Write your formula like the following:

=num(month(now()))

This will return the numerical version of the month.

Stan

View solution in original post

2 Replies
Highlighted
Not applicable

Write your formula like the following:

=num(month(now()))

This will return the numerical version of the month.

Stan

View solution in original post

Highlighted
Specialist
Specialist

Thanks.

That did the trick!