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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
adiarnon
Creator III
Creator III

month in Two digits

HI,

i want to get the current month in two digits. (01,02,03,04,05,06,07,08,09,10,11,12)

i need a expression - but without an IF.

can someone help?

1 Solution

Accepted Solutions
swuehl
MVP
MVP

num(MonthField, '00')

View solution in original post

4 Replies
swuehl
MVP
MVP

num(MonthField, '00')

Ibobob70
Contributor II
Contributor II

Hi

what if I have 2 digits month number and i want month name?

BrunPierre
Partner - Master II
Partner - Master II

Date(Date#([Month Number], 'MM'), 'MMM')

or

Pick(Match([Month Number], '01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12'),
'January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December')

luizclaudio
Creator
Creator

Does the monthname(data) function not solve what you need?