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

    Add Day Function ?

    thereverend

      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.