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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
P_qlik
Partner - Contributor III
Partner - Contributor III
‎2021-04-27 06:05 AM

format of month

Hi,

I have this formula: Num(Month(Date(today(), 'MM'))): the result is 4

how can I have format 04 for month?

Thank you

581 Views
0 Likes
1 Solution

Accepted Solutions
MayilVahanan
MVP
MVP
‎2021-04-27 06:21 AM

HI @P_qlik 

Try like below

Num(Month(Date(today())),'00')

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

574 Views
1 Reply
MayilVahanan
MVP
MVP
‎2021-04-27 06:21 AM

HI @P_qlik 

Try like below

Num(Month(Date(today())),'00')

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
575 Views