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())
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Days in part of the month 1
Getting the date in Calendar View 5
Date Calculator 5
Access Access 2010 - Date()-1 and times in query 0
Showing Date Ranges For Each Day In Outlook 2003 1
Format 6
Does VBA support flattening/serializing to "binary" string? 6
calculate a date X number of days before/after given date 1

Top