Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Giovane
Creator
Creator

Issue Related to Month Date Format

Who can help me?

When I do Month(Date) - And Date has the format DD/MM/YYYY - I got, for example, dez as the result. How do I do to get 12, instead of dez, as the result? 

Thanks a lot !!!

 

 

 

 

1 Solution

Accepted Solutions
MindaugasBacius
Partner - Specialist III
Partner - Specialist III

I would like to improve Mwoolf solution a liitle:
Num(Month(Date), '00')

Now you will get 01, 02, 03 ... 12. In times when you will for example concatenate Year and Month as 2019-01, 2019-02, 2019-03 ... 2019-12 that will provide consistent visualization.
Without formatting you will get 1, 2, 3 ... 12 and Year month field will look like this 2019-1, 2019-2, 2019-3 ... 2019-12.

View solution in original post

4 Replies
m_woolf
Master II
Master II

Try:

num(Month(Date))

nilaksh92
Partner - Contributor III
Partner - Contributor III

Please try to implement like this.

 

=Num(Month(Date(now(),'DD/MM/YYYY')))

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

I would like to improve Mwoolf solution a liitle:
Num(Month(Date), '00')

Now you will get 01, 02, 03 ... 12. In times when you will for example concatenate Year and Month as 2019-01, 2019-02, 2019-03 ... 2019-12 that will provide consistent visualization.
Without formatting you will get 1, 2, 3 ... 12 and Year month field will look like this 2019-1, 2019-2, 2019-3 ... 2019-12.
Giovane
Creator
Creator
Author

Best answer...your tip fixed completely my issue.

Thanks for all the contributions.