topic Filter by Date in QlikView https://community.qlik.com/t5/QlikView/Filter-by-Date/m-p/323542#M1196236 <HTML><HEAD></HEAD><BODY><P>Let's us say that your field is called DATE.</P><P>at the end of the script you can make</P><P>Load distinct DATE,</P><P>MONTH(DATE) AS InvMonth,</P><P>Year(DATE) as InvYear</P><P>Resident YourTable</P><P></P><P>Maybe QlikView didn't recognize your field as a date yet. So, if your field is MMDDYYYY, the script would be:</P><P></P><P>Load distinct DATE,</P><P>LEFT(DATE,2) AS InvMonth,</P><P>right(DATE,4) as InvYear</P><P>Resident YourTable</P></BODY></HTML> Mon, 25 Apr 2011 18:02:05 GMT erichshiino 2011-04-25T18:02:05Z Filter by Date https://community.qlik.com/t5/QlikView/Filter-by-Date/m-p/323541#M1196235 <HTML><HEAD></HEAD><BODY><P>I have a date field which is month day year. I want to see only those records where this date field is the in Inv Month and Inv Year selected. How would do that?</P></BODY></HTML> Mon, 25 Apr 2011 17:40:19 GMT https://community.qlik.com/t5/QlikView/Filter-by-Date/m-p/323541#M1196235 2011-04-25T17:40:19Z Filter by Date https://community.qlik.com/t5/QlikView/Filter-by-Date/m-p/323542#M1196236 <HTML><HEAD></HEAD><BODY><P>Let's us say that your field is called DATE.</P><P>at the end of the script you can make</P><P>Load distinct DATE,</P><P>MONTH(DATE) AS InvMonth,</P><P>Year(DATE) as InvYear</P><P>Resident YourTable</P><P></P><P>Maybe QlikView didn't recognize your field as a date yet. So, if your field is MMDDYYYY, the script would be:</P><P></P><P>Load distinct DATE,</P><P>LEFT(DATE,2) AS InvMonth,</P><P>right(DATE,4) as InvYear</P><P>Resident YourTable</P></BODY></HTML> Mon, 25 Apr 2011 18:02:05 GMT https://community.qlik.com/t5/QlikView/Filter-by-Date/m-p/323542#M1196236 erichshiino 2011-04-25T18:02:05Z