topic Does my date fall within a range? in QlikView https://community.qlik.com/t5/QlikView/Does-my-date-fall-within-a-range/m-p/379243#M702768 <HTML><HEAD></HEAD><BODY><P><STRONG style=": ; color: #0000ff; font-size: 8pt;">&nbsp; </STRONG></P><P>Hi Guys,</P><P></P><P>I was hoping someone could help me.</P><P>Im trying to return a series of results whereby a holiday is currently going on, (ie: today's date is in between the Departure Date and the Return Date).</P><P></P><P>I dont have a database field for "Return Date" so I calculated this using <SPAN style="font-family: Calibri;">the formula:&nbsp; </SPAN><EM>[Departure Date]+[TD Duration]</EM></P><P></P><P>Can you tell me whether or not my formula below makes sense:</P><P></P><DIV><SPAN style="color: #333333;"><DIV><SPAN style="color: #ff0000;"><DIV><SPAN style="font-size: 8pt;">&nbsp; </SPAN><SPAN style="font-size: 8pt;"><P><SPAN style="font-size: 12pt;">= if ( [Departure Date] &lt;today() ,if( ( [Departure Date] + [TD Duration] ) &gt;today() , "Yes" , "No" ) , "No" )</SPAN></P><P></P><P></P><P></P><P></P><P></P></SPAN></DIV></SPAN></DIV><P></P></SPAN></DIV><P>Many thanks</P><P>Christof</P></BODY></HTML> Mon, 20 Aug 2012 16:34:32 GMT cmccafferty 2012-08-20T16:34:32Z Does my date fall within a range? https://community.qlik.com/t5/QlikView/Does-my-date-fall-within-a-range/m-p/379243#M702768 <HTML><HEAD></HEAD><BODY><P><STRONG style=": ; color: #0000ff; font-size: 8pt;">&nbsp; </STRONG></P><P>Hi Guys,</P><P></P><P>I was hoping someone could help me.</P><P>Im trying to return a series of results whereby a holiday is currently going on, (ie: today's date is in between the Departure Date and the Return Date).</P><P></P><P>I dont have a database field for "Return Date" so I calculated this using <SPAN style="font-family: Calibri;">the formula:&nbsp; </SPAN><EM>[Departure Date]+[TD Duration]</EM></P><P></P><P>Can you tell me whether or not my formula below makes sense:</P><P></P><DIV><SPAN style="color: #333333;"><DIV><SPAN style="color: #ff0000;"><DIV><SPAN style="font-size: 8pt;">&nbsp; </SPAN><SPAN style="font-size: 8pt;"><P><SPAN style="font-size: 12pt;">= if ( [Departure Date] &lt;today() ,if( ( [Departure Date] + [TD Duration] ) &gt;today() , "Yes" , "No" ) , "No" )</SPAN></P><P></P><P></P><P></P><P></P><P></P></SPAN></DIV></SPAN></DIV><P></P></SPAN></DIV><P>Many thanks</P><P>Christof</P></BODY></HTML> Mon, 20 Aug 2012 16:34:32 GMT https://community.qlik.com/t5/QlikView/Does-my-date-fall-within-a-range/m-p/379243#M702768 cmccafferty 2012-08-20T16:34:32Z Re: Does my date fall within a range? https://community.qlik.com/t5/QlikView/Does-my-date-fall-within-a-range/m-p/379244#M702769 <HTML><HEAD></HEAD><BODY><P>Christof,</P><P></P><P>Logically it is correct.&nbsp; It could look simpler though:</P><P></P><P><SPAN style="font-size: 12pt;">= if ([Departure Date] &lt;today() AND&nbsp; ( [Departure Date] + [TD Duration] ) &gt;today(), "Yes", No" ) </SPAN></P><P></P><P>Regards,</P><P>Michael </P></BODY></HTML> Mon, 20 Aug 2012 16:45:26 GMT https://community.qlik.com/t5/QlikView/Does-my-date-fall-within-a-range/m-p/379244#M702769 Anonymous 2012-08-20T16:45:26Z