Date Manipulation to Get Previous Day 1

[scripter73]

Hi,

Does anyone know of function to manipulate today's date to obtain yesterday's date?

For example, in my code I use the Date keyword which returns 5/11/01. However, I'd like to have 5/10/01. I realize that if a function doesn't exist, I'll have to subtract 1 from my DD and then use the MM to determine the number of days for a particular month, etc., but if there's an easier way, I thought I'd ask.

Thanks in advance for all the cool help!
scripter73

 

[link9]

so you have a variable of subType date called, 'theDate' -- do this to take a day off and place the results into 'theNewDate'--

theNewDate = DateAdd("D", -1, theDate)


Paul Prewett

 

[scripter73]

Hi Paul!

That worked great! You're the best!

scripter73