Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
swuehl
MVP
MVP

Try the num() function, like

=num(month([PurchaseDate]))

View solution in original post

3 Replies
swuehl
MVP
MVP

Try the num() function, like

=num(month([PurchaseDate]))

Not applicable
Author

thank you.

MarcoWedel

=Date([PurchaseDate], 'M')

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

regards

Marco