|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
November 6th 06, 08:39 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
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 
|
|
#2
November 6th 06, 08:43 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I put the name of the day, i.e. Sunday, beside the date? | verandah | Outlook - Calandaring | 1 | August 9th 06 08:52 PM |
| detail version - day of week beside date | jotylo | Outlook - Calandaring | 1 | April 20th 06 11:37 PM |
| How do I get day and date togetherin calender. | WhiteMick | Outlook - Calandaring | 1 | March 28th 06 11:39 AM |
| How do I get day and date togetherin calender. | WhiteMick | Outlook - Calandaring | 0 | March 27th 06 11:47 PM |
| 31 day month does not startup on current date | BobM | Outlook - Calandaring | 1 | February 1st 06 01:52 AM |
Hybrid Mode
