topic Add Day Function ? in QlikView https://community.qlik.com/t5/QlikView/Add-Day-Function/m-p/189401#M715428 <HTML><HEAD></HEAD><BODY><P>Hi, I need help with this script, basically what I need is the date of Today() - 1 In Ansi SQL</P><P>This is what Ive got=</P><P></P><P style="font-weight: bold"></P><P style="font-weight: bold"></P><B></B><P style="font-weight: bold"></P> <B>Yesterday = Today() - 1;</B> <P></P><P></P><P></P><BR /><BR /> <P></P><P>Yesterday_Ansi = YEAR(Yesterday) + MONTH(Yesterday) + Day(Yesterday) Yesterday= Today() - 1;</P><P>Im getting an error on the second Line, becuase it appears that the YEAR, MONTH &amp; DAY Functions expect the Variable Yesterday in date format, but when I use the minus operator it gets saved as an integer.</P><P>Any Ideas?</P><P>Thank you in advance,</P><P>Jose.</P></BODY></HTML> Mon, 22 Mar 2010 19:35:49 GMT 2010-03-22T19:35:49Z Add Day Function ? https://community.qlik.com/t5/QlikView/Add-Day-Function/m-p/189401#M715428 <HTML><HEAD></HEAD><BODY><P>Hi, I need help with this script, basically what I need is the date of Today() - 1 In Ansi SQL</P><P>This is what Ive got=</P><P></P><P style="font-weight: bold"></P><P style="font-weight: bold"></P><B></B><P style="font-weight: bold"></P> <B>Yesterday = Today() - 1;</B> <P></P><P></P><P></P><BR /><BR /> <P></P><P>Yesterday_Ansi = YEAR(Yesterday) + MONTH(Yesterday) + Day(Yesterday) Yesterday= Today() - 1;</P><P>Im getting an error on the second Line, becuase it appears that the YEAR, MONTH &amp; DAY Functions expect the Variable Yesterday in date format, but when I use the minus operator it gets saved as an integer.</P><P>Any Ideas?</P><P>Thank you in advance,</P><P>Jose.</P></BODY></HTML> Mon, 22 Mar 2010 19:35:49 GMT https://community.qlik.com/t5/QlikView/Add-Day-Function/m-p/189401#M715428 2010-03-22T19:35:49Z Add Day Function ? https://community.qlik.com/t5/QlikView/Add-Day-Function/m-p/189402#M715429 <HTML><HEAD></HEAD><BODY><P>Not positive, but try this:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />Yesterday = Date#(Today() - 1)<BR /></PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Mon, 22 Mar 2010 19:56:40 GMT https://community.qlik.com/t5/QlikView/Add-Day-Function/m-p/189402#M715429 2010-03-22T19:56:40Z