Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Numeric Value for Month

I have a date field called PurchaseDate.  Instead of it rendering Jan, Feb, Mar, etc.  I want the numeric value so 1,2,3, etc.  I have tried different things and it is not working.  I know this is simple.

1 Solution

Accepted Solutions
MVP
MVP

Re: Numeric Value for Month

Try the num() function, like

=num(month([PurchaseDate]))

3 Replies
MVP
MVP

Re: Numeric Value for Month

Try the num() function, like

=num(month([PurchaseDate]))

Not applicable

Re: Numeric Value for Month

thank you.

Re: Numeric Value for Month

=Date([PurchaseDate], 'M')

But this only changes the format while preserving the internal date representation.

regards

Marco

Community Browser