topic Re: last day of month in QlikView https://community.qlik.com/t5/QlikView/last-day-of-month/m-p/499992#M186828 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this</P><P>=MakeDate(2013,Month(Date(Date#('May','MMM')))) ==&gt; Returen 01-05-2013</P><P>=MonthEnd(MakeDate(2013,Month(Date(Date#('May','MMM'))))) ==&gt; Return 31-05-2013</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Mon, 24 Jun 2013 06:45:42 GMT Sokkorn 2013-06-24T06:45:42Z last day of month https://community.qlik.com/t5/QlikView/last-day-of-month/m-p/499990#M186826 <HTML><HEAD></HEAD><BODY><P>AOA</P><P></P><P>I HAVE TWO FIELD</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="68" style="width: 149px; border: 1px solid rgb(0, 0, 0); height: 63px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>MAX_YEAR</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>MAX_MON</STRONG></SPAN></TH></TR><TR><TD><BR /></TD><TD><BR /></TD></TR><TR><TD>2013</TD><TD>MAY</TD></TR></TBODY></TABLE><P></P><P>WHICH IS THE MONTH AND YEAR,</P><P>&nbsp; WHEN DATA WAS LOADED</P><P></P><P></P><P>NO I WANT THE LAST DAY OF THAT MAX MONTH IN PROPER DATE FORMATE</P><P>(i.e 31-MAY-2013)</P><P></P><P>I TRIED</P><P></P><P>=MAKEMONTH(MAX_YEAR,MAX_MONTH,31) NOT WORKING....</P><P></P><P>ANY ADVICE</P></BODY></HTML> Mon, 24 Jun 2013 06:28:25 GMT https://community.qlik.com/t5/QlikView/last-day-of-month/m-p/499990#M186826 2013-06-24T06:28:25Z Re: last day of month https://community.qlik.com/t5/QlikView/last-day-of-month/m-p/499991#M186827 <HTML><HEAD></HEAD><BODY><P>TRY THIS</P><P></P><P>=DATE(MonthEnd(Date#(MAX_MON &amp; '-' &amp; MAX_YEAR,'MMM-YYYY')),'DD-MMM-YYYY')</P><P></P><P>SEE ATTACHEMENT</P></BODY></HTML> Mon, 24 Jun 2013 06:39:27 GMT https://community.qlik.com/t5/QlikView/last-day-of-month/m-p/499991#M186827 2013-06-24T06:39:27Z Re: last day of month https://community.qlik.com/t5/QlikView/last-day-of-month/m-p/499992#M186828 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this</P><P>=MakeDate(2013,Month(Date(Date#('May','MMM')))) ==&gt; Returen 01-05-2013</P><P>=MonthEnd(MakeDate(2013,Month(Date(Date#('May','MMM'))))) ==&gt; Return 31-05-2013</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Mon, 24 Jun 2013 06:45:42 GMT https://community.qlik.com/t5/QlikView/last-day-of-month/m-p/499992#M186828 Sokkorn 2013-06-24T06:45:42Z Re: last day of month https://community.qlik.com/t5/QlikView/last-day-of-month/m-p/499993#M186829 <HTML><HEAD></HEAD><BODY><P>thnks of all who replied... love u guys</P></BODY></HTML> Mon, 24 Jun 2013 09:44:58 GMT https://community.qlik.com/t5/QlikView/last-day-of-month/m-p/499993#M186829 2013-06-24T09:44:58Z