SQLTeam.com | Weblogs | Forums

Subtract one day from getdate()

I'm trying to subtract one day from the current date to keep track of our patient census. I've tried several of the results in other forums but they didn't seem to work.

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

Here is the MSDN page on date arithmetic.