Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 = Today() - 1;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.
Any Ideas?
Thank you in advance,
Jose.
Not positive, but try this:
Yesterday = Date#(Today() - 1)