Subtract one day from getdate()

[JamesK]

Did the reply I posted in your other thread answer your question? If not please reply.

Here is the MSDN page on date arithmetic.