topic Search Expression for Between Timestamps in QlikView https://community.qlik.com/t5/QlikView/Search-Expression-for-Between-Timestamps/m-p/171545#M41506 <HTML><HEAD></HEAD><BODY><P>Check your DateFormat. It should be like this:</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">SET DateFormat='M/D/YYYY';</PRE></BLOCKQUOTE><BR /><BR /> <P>And type the date in this format for your search expression.</P></BODY></HTML> Tue, 24 Aug 2010 14:59:45 GMT 2010-08-24T14:59:45Z Search Expression for Between Timestamps https://community.qlik.com/t5/QlikView/Search-Expression-for-Between-Timestamps/m-p/171544#M41505 <HTML><HEAD></HEAD><BODY><P>I'm trying to select the results between 2 timestamps in a multibox using the search expression.</P><P>I'm able to accomplish something similar for dates, by providing "&gt;=2010-07-01 &lt;2010-08-01".</P><P>When I try this with timestamps, there is no reduction in the result set.</P><P>Any suggestions?</P><P>B</P></BODY></HTML> Mon, 23 Aug 2010 20:47:48 GMT https://community.qlik.com/t5/QlikView/Search-Expression-for-Between-Timestamps/m-p/171544#M41505 bnichol 2010-08-23T20:47:48Z Search Expression for Between Timestamps https://community.qlik.com/t5/QlikView/Search-Expression-for-Between-Timestamps/m-p/171545#M41506 <HTML><HEAD></HEAD><BODY><P>Check your DateFormat. It should be like this:</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">SET DateFormat='M/D/YYYY';</PRE></BLOCKQUOTE><BR /><BR /> <P>And type the date in this format for your search expression.</P></BODY></HTML> Tue, 24 Aug 2010 14:59:45 GMT https://community.qlik.com/t5/QlikView/Search-Expression-for-Between-Timestamps/m-p/171545#M41506 2010-08-24T14:59:45Z