topic Re: month in Two digits in QlikView https://community.qlik.com/t5/QlikView/month-in-Two-digits/m-p/577783#M1102737 <HTML><HEAD></HEAD><BODY><P>num(MonthField, '00')</P></BODY></HTML> Sun, 30 Mar 2014 11:48:58 GMT swuehl 2014-03-30T11:48:58Z month in Two digits https://community.qlik.com/t5/QlikView/month-in-Two-digits/m-p/577782#M1102736 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>i want to get the current month in two digits. (01,02,03,04,05,06,07,08,09,10,11,12)</P><P>i need a expression - but without an IF.</P><P></P><P>can someone help?</P></BODY></HTML> Sun, 30 Mar 2014 11:43:22 GMT https://community.qlik.com/t5/QlikView/month-in-Two-digits/m-p/577782#M1102736 adiarnon 2014-03-30T11:43:22Z Re: month in Two digits https://community.qlik.com/t5/QlikView/month-in-Two-digits/m-p/577783#M1102737 <HTML><HEAD></HEAD><BODY><P>num(MonthField, '00')</P></BODY></HTML> Sun, 30 Mar 2014 11:48:58 GMT https://community.qlik.com/t5/QlikView/month-in-Two-digits/m-p/577783#M1102737 swuehl 2014-03-30T11:48:58Z Re: month in Two digits https://community.qlik.com/t5/QlikView/month-in-Two-digits/m-p/2471081#M1225930 <P>Hi</P> <P>what if I have 2 digits month number and i want month name?</P> Wed, 17 Jul 2024 06:23:44 GMT https://community.qlik.com/t5/QlikView/month-in-Two-digits/m-p/2471081#M1225930 Ibobob70 2024-07-17T06:23:44Z Re: month in Two digits https://community.qlik.com/t5/QlikView/month-in-Two-digits/m-p/2471090#M1225931 <P>Date(Date#([Month Number], 'MM'), 'MMM')</P> <P>or</P> <P>Pick(Match([Month Number], '01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12'),<BR />'January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December')</P> Wed, 17 Jul 2024 07:17:07 GMT https://community.qlik.com/t5/QlikView/month-in-Two-digits/m-p/2471090#M1225931 BrunPierre 2024-07-17T07:17:07Z Re: month in Two digits https://community.qlik.com/t5/QlikView/month-in-Two-digits/m-p/2471385#M1225939 Does the monthname(data) function not solve what you need?<BR /><BR /> <BR /> Thu, 18 Jul 2024 07:57:32 GMT https://community.qlik.com/t5/QlikView/month-in-Two-digits/m-p/2471385#M1225939 luizclaudio 2024-07-18T07:57:32Z