topic Timestamp issue in monthend function in QlikView https://community.qlik.com/t5/QlikView/Timestamp-issue-in-monthend-function/m-p/129963#M601310 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have date in timestamp format like "01/30/2018 10:56:01 AM". Now I want previous 2 months data.</P><P></P><P>I tried this,</P><P>Vmaxdate=date(peek(maxdate));</P><P>Vmonthstart=monthstart(maxdate,-2);</P><P>Vmonthend=monthend(maxdate,-1);</P><P></P><P>Issue is,</P><P>I am getting the date from Aug 1st to sep 29th but I need Aug 1st to sep 30th. Could you please let me know how to handle this kind of problem. I know that monthend falls into time 11:59.</P></BODY></HTML> Tue, 23 Oct 2018 18:17:26 GMT Anonymous 2018-10-23T18:17:26Z Timestamp issue in monthend function https://community.qlik.com/t5/QlikView/Timestamp-issue-in-monthend-function/m-p/129963#M601310 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have date in timestamp format like "01/30/2018 10:56:01 AM". Now I want previous 2 months data.</P><P></P><P>I tried this,</P><P>Vmaxdate=date(peek(maxdate));</P><P>Vmonthstart=monthstart(maxdate,-2);</P><P>Vmonthend=monthend(maxdate,-1);</P><P></P><P>Issue is,</P><P>I am getting the date from Aug 1st to sep 29th but I need Aug 1st to sep 30th. Could you please let me know how to handle this kind of problem. I know that monthend falls into time 11:59.</P></BODY></HTML> Tue, 23 Oct 2018 18:17:26 GMT https://community.qlik.com/t5/QlikView/Timestamp-issue-in-monthend-function/m-p/129963#M601310 Anonymous 2018-10-23T18:17:26Z Re: Timestamp issue in monthend function https://community.qlik.com/t5/QlikView/Timestamp-issue-in-monthend-function/m-p/129964#M601311 <HTML><HEAD></HEAD><BODY><P>please post a small sample app that demonstrates your issue.</P></BODY></HTML> Tue, 23 Oct 2018 19:39:03 GMT https://community.qlik.com/t5/QlikView/Timestamp-issue-in-monthend-function/m-p/129964#M601311 swuehl 2018-10-23T19:39:03Z