Microsoft Outlook email - The day before a given date

Outlook Banter (http://www.outlookbanter.com/)

- Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)

- - The day before a given date (http://www.outlookbanter.com/outlook-vba/32129-day-before-given-date.html)

Paul Batt

November 6th 06 08:39 PM

The day before a given date

I need to read the date of the day before every given date in European form
(dd.mm.yyyy) from the calendar into a string variable. For instance I have a
variable day1 = "01.11.2006" and need this one minus one day (day0 =
"31.10.2006"). I don't even know where to start doing this in VBA. Could
someone help me a little? Thank you, Paul

neo [mvp outlook]

November 6th 06 08:43 PM

The day before a given date

I believe you are after the DateAdd function.

dYesterday = DateAdd("d", -1, Now())

"Paul Batt" wrote in message
...
I need to read the date of the day before every given date in European form
(dd.mm.yyyy) from the calendar into a string variable. For instance I have
a variable day1 = "01.11.2006" and need this one minus one day (day0 =
"31.10.2006"). I don't even know where to start doing this in VBA. Could
someone help me a little? Thank you, Paul

All times are GMT +1. The time now is 08:33 PM.