topic Re: How to pull last months data? in QlikView https://community.qlik.com/t5/QlikView/How-to-pull-last-months-data/m-p/1379200#M810919 <HTML><HEAD></HEAD><BODY><P>In the qvw where this doesn't work.... have you checked if QlikView reads your date field as date or text? May be you will need interpretation functions such as&nbsp; Date#() or TimeStamp#() to help qlikview understand your date and time field?</P></BODY></HTML> Mon, 02 Oct 2017 11:26:48 GMT sunny_talwar 2017-10-02T11:26:48Z How to pull last months data? https://community.qlik.com/t5/QlikView/How-to-pull-last-months-data/m-p/1379199#M810918 <HTML><HEAD></HEAD><BODY><P>Hi , </P><P></P><P>I have got this strange behaviour while loading the data.</P><P>It is working on one of the QVW but it is not doing the job i wanted in the other QVW.</P><P>Requirement: I want to show only previous month data. in my case Until Sep' 2017.</P><P>I have used this in the load script ' where Date(Floor("recorded_at")) &lt; MonthStart(today())'</P><P>It is working but not in other qvw . all the same fields and table.</P><P>Any help pls</P><P></P><P>regards,</P><P>Vamsi.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-pull-last-months-data/m-p/1379199#M810918 Anonymous 2020-11-25T16:16:04Z Re: How to pull last months data? https://community.qlik.com/t5/QlikView/How-to-pull-last-months-data/m-p/1379200#M810919 <HTML><HEAD></HEAD><BODY><P>In the qvw where this doesn't work.... have you checked if QlikView reads your date field as date or text? May be you will need interpretation functions such as&nbsp; Date#() or TimeStamp#() to help qlikview understand your date and time field?</P></BODY></HTML> Mon, 02 Oct 2017 11:26:48 GMT https://community.qlik.com/t5/QlikView/How-to-pull-last-months-data/m-p/1379200#M810919 sunny_talwar 2017-10-02T11:26:48Z