The day before a given date

P

Paul Batt

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
 
N

neo [mvp outlook]

I believe you are after the DateAdd function.

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