topic Re: Get Day in Month in QlikView https://community.qlik.com/t5/QlikView/Get-Day-in-Month/m-p/426792#M1149689 <HTML><HEAD></HEAD><BODY><P>try this</P><P></P><P><STRONG>round(MonthEnd(Date(datefield,'MMM-YYYY'))-MonthStart(</STRONG><STRONG>datefield,'MMM-YYYY'</STRONG><STRONG>))&nbsp; as [no_of_days]</STRONG></P></BODY></HTML> Mon, 06 May 2013 06:30:35 GMT 2013-05-06T06:30:35Z Get Day in Month https://community.qlik.com/t5/QlikView/Get-Day-in-Month/m-p/426787#M1149684 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I would like to get number of day in Month. How to write script in Qlikview?</P><P></P><P></P><P>Thank,</P><P>Ratana</P></BODY></HTML> Mon, 06 May 2013 03:11:40 GMT https://community.qlik.com/t5/QlikView/Get-Day-in-Month/m-p/426787#M1149684 2013-05-06T03:11:40Z Re: Get Day in Month https://community.qlik.com/t5/QlikView/Get-Day-in-Month/m-p/426788#M1149685 <HTML><HEAD></HEAD><BODY><P>Hi Ratana,</P><P></P><P>Let try : </P><P>Round(MonthEnd(DateField)-MonthStart(DateField))&nbsp;&nbsp;&nbsp;&nbsp; AS [NumberOfDay]</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Mon, 06 May 2013 04:22:11 GMT https://community.qlik.com/t5/QlikView/Get-Day-in-Month/m-p/426788#M1149685 Sokkorn 2013-05-06T04:22:11Z Re: Get Day in Month https://community.qlik.com/t5/QlikView/Get-Day-in-Month/m-p/426789#M1149686 <HTML><HEAD></HEAD><BODY><P>Day(DateFieldname) as Day</P></BODY></HTML> Mon, 06 May 2013 04:44:36 GMT https://community.qlik.com/t5/QlikView/Get-Day-in-Month/m-p/426789#M1149686 er_mohit 2013-05-06T04:44:36Z Re: Get Day in Month https://community.qlik.com/t5/QlikView/Get-Day-in-Month/m-p/426790#M1149687 <HTML><HEAD></HEAD><BODY><P><STRONG>round(MonthEnd(Today())-MonthStart(Today()))&nbsp; as [no_of_days]</STRONG></P><P></P><P>OR TRY THIS</P><P><STRONG>Day(MonthEnd(Makedate(Year(Today()))))&nbsp;&nbsp; AS&nbsp;&nbsp; [No_of_day]</STRONG></P></BODY></HTML> Mon, 06 May 2013 05:03:18 GMT https://community.qlik.com/t5/QlikView/Get-Day-in-Month/m-p/426790#M1149687 2013-05-06T05:03:18Z Re: Get Day in Month https://community.qlik.com/t5/QlikView/Get-Day-in-Month/m-p/426791#M1149688 <HTML><HEAD></HEAD><BODY><P>Thank for your reply....</P><P>What i expected is getting number of each month:</P><P>Ex:</P><P>Jan-2013&nbsp;&nbsp;&nbsp;&nbsp; is 31</P><P>Feb-2013&nbsp;&nbsp;&nbsp;&nbsp; is 28</P><P></P><P></P><P>How to get this?</P><P></P><P>Regards,</P><P>Ratana</P></BODY></HTML> Mon, 06 May 2013 06:14:44 GMT https://community.qlik.com/t5/QlikView/Get-Day-in-Month/m-p/426791#M1149688 2013-05-06T06:14:44Z Re: Get Day in Month https://community.qlik.com/t5/QlikView/Get-Day-in-Month/m-p/426792#M1149689 <HTML><HEAD></HEAD><BODY><P>try this</P><P></P><P><STRONG>round(MonthEnd(Date(datefield,'MMM-YYYY'))-MonthStart(</STRONG><STRONG>datefield,'MMM-YYYY'</STRONG><STRONG>))&nbsp; as [no_of_days]</STRONG></P></BODY></HTML> Mon, 06 May 2013 06:30:35 GMT https://community.qlik.com/t5/QlikView/Get-Day-in-Month/m-p/426792#M1149689 2013-05-06T06:30:35Z