Discussion Board for collaboration on QlikView Scripting.
Hi, I need help with this script, basically what I need is the date of Today() - 1 In Ansi SQL
This is what Ive got=
Yesterday_Ansi = YEAR(Yesterday) + MONTH(Yesterday) + Day(Yesterday) Yesterday= Today() - 1;
Im getting an error on the second Line, becuase it appears that the YEAR, MONTH & DAY Functions expect the Variable Yesterday in date format, but when I use the minus operator it gets saved as an integer.
Thank you in advance,
Go to Solution.
Not positive, but try this:
Yesterday = Date#(Today() - 1)