1 Reply Latest reply: Mar 22, 2010 3:56 PM by Community Administrator RSS

    Add Day Function ?


      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,