Add Day Function ?

[#1]

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.

[#2 · Accepted solution]

Not positive, but try this:

Yesterday = Date#(Today() - 1)