topic Re: Comparing Dates in QlikView https://community.qlik.com/t5/QlikView/Comparing-Dates/m-p/431808#M485742 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>Try this:</P><P></P><P>step1: Create two variablt say: vstartdate and venddate</P><P>step2: create two calander objects/inputbox to assigne the desired dates to those variables..</P><P></P><P>step3: you can use those variables in the setanalysis like</P><P></P><P>=only({&lt;opendate={"&gt;=$(vstartdate)"},closedate={"&lt;=$(venddate)"}&gt;}tickets)</P><P></P><P></P><P>HTH</P><P>Sushil</P></BODY></HTML> Tue, 09 Apr 2013 11:01:56 GMT sushil353 2013-04-09T11:01:56Z Comparing Dates https://community.qlik.com/t5/QlikView/Comparing-Dates/m-p/431807#M485741 <HTML><HEAD></HEAD><BODY><P>I have a request for a QV model where the user can enter a from date and to date.&nbsp; The from and to dates will be used to determine a range for showing all tickets that were either open or closed during that period.&nbsp; I have both open and closed dates on my ticket table.&nbsp; Does anyone have any recommendations on how to only select only the tickets that were either open or closed during the range the user selected.</P><P>Thanks</P></BODY></HTML> Mon, 08 Apr 2013 14:02:28 GMT https://community.qlik.com/t5/QlikView/Comparing-Dates/m-p/431807#M485741 tmumaw 2013-04-08T14:02:28Z Re: Comparing Dates https://community.qlik.com/t5/QlikView/Comparing-Dates/m-p/431808#M485742 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>Try this:</P><P></P><P>step1: Create two variablt say: vstartdate and venddate</P><P>step2: create two calander objects/inputbox to assigne the desired dates to those variables..</P><P></P><P>step3: you can use those variables in the setanalysis like</P><P></P><P>=only({&lt;opendate={"&gt;=$(vstartdate)"},closedate={"&lt;=$(venddate)"}&gt;}tickets)</P><P></P><P></P><P>HTH</P><P>Sushil</P></BODY></HTML> Tue, 09 Apr 2013 11:01:56 GMT https://community.qlik.com/t5/QlikView/Comparing-Dates/m-p/431808#M485742 sushil353 2013-04-09T11:01:56Z