topic Today()-1 won't work how will I select yesterday in QlikView https://community.qlik.com/t5/QlikView/Today-1-won-t-work-how-will-I-select-yesterday/m-p/314863#M708398 <HTML><HEAD></HEAD><BODY><P> Thanks! Finally it will work! Usefull help around here, </P></BODY></HTML> Tue, 20 Dec 2011 15:14:49 GMT 2011-12-20T15:14:49Z Today()-1 won't work how will I select yesterday https://community.qlik.com/t5/QlikView/Today-1-won-t-work-how-will-I-select-yesterday/m-p/314861#M708396 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>I'm trying to always select yesterday in my data set because we don't have real life data and yesterday is the most recent data. But when selected an action in triggers i use today() result is today because we reload after 12pm. </P><P></P><P>So i want the data from yesterday&nbsp; I tried today()-1 it doesn't work. Hope anyone could help me. Thanks!</P></BODY></HTML> Tue, 20 Dec 2011 15:07:07 GMT https://community.qlik.com/t5/QlikView/Today-1-won-t-work-how-will-I-select-yesterday/m-p/314861#M708396 2011-12-20T15:07:07Z Re: Today()-1 won't work how will I select yesterday https://community.qlik.com/t5/QlikView/Today-1-won-t-work-how-will-I-select-yesterday/m-p/314862#M708397 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Just try instead</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P>=Date(Today() -1)</P></PRE><P></P><P>The Date() function should return in the same format your date field is. </P><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Tue, 20 Dec 2011 15:12:09 GMT https://community.qlik.com/t5/QlikView/Today-1-won-t-work-how-will-I-select-yesterday/m-p/314862#M708397 Miguel_Angel_Baeyens 2011-12-20T15:12:09Z Today()-1 won't work how will I select yesterday https://community.qlik.com/t5/QlikView/Today-1-won-t-work-how-will-I-select-yesterday/m-p/314863#M708398 <HTML><HEAD></HEAD><BODY><P> Thanks! Finally it will work! Usefull help around here, </P></BODY></HTML> Tue, 20 Dec 2011 15:14:49 GMT https://community.qlik.com/t5/QlikView/Today-1-won-t-work-how-will-I-select-yesterday/m-p/314863#M708398 2011-12-20T15:14:49Z