How do I calculate the next recurrence date?

Status
Not open for further replies.
W

Warren Gamley

I am trying to show a column that tells me the next recurrence date of an

appointment after today. For example, if the start date of an appointment was

01/01/2007 and the appointment recurred annually, then the next recurrence

date after today (07/26/2009) would be 01/01/2010. How do I create a formula

for this in a column within Outlook 2007?
 
D

Dmitry Streblechenko

Outlook Object Model only lets you pass a date to

RecurrencePattern.GetOccurrence. so you pretty much need to know the date in

advance unless you loop through all available dates and handles a returned

COM exception if thereis no occurrence on the given date.

<plug> Redemption on the other hand lets you pass either a date or an

integer index -

http://www.dimastr.com/redemption/rdo/rdorecurrencepattern.htm </plug

Dmitry Streblechenko (MVP)

-

"Warren Gamley" <Warren Gamley> wrote in message

news:6214BA78-330B-4FD1-A9ED-06D0BCB79FBF@microsoft.com...
> I am trying to show a column that tells me the next recurrence date of an
> appointment after today. For example, if the start date of an appointment
> was
> 01/01/2007 and the appointment recurred annually, then the next recurrence
> date after today (07/26/2009) would be 01/01/2010. How do I create a
> formula
> for this in a column within Outlook 2007?
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
ThinkToday Calculate reply time of outlook mail Using Outlook 1
Diane Poremsky Calculate Days Overdue and Days to Complete Tasks New Slipstick.com Articles 0
H Calculate the Response time of a thread Outlook VBA and Custom Forms 3
F Automatically calculate age from birthdate Outlook VBA and Custom Forms 2
T Here is Practical Explanation about Next Life, Purpose of Human Life, philosophical/religious facts, theories etc. Using Outlook 0
D Add date next to day name in Outlook Today calendar view Using Outlook 1
D after delete mail, open the next one Outlook VBA and Custom Forms 0
witzker Macro to set contact reminder to next day 9:00 Outlook VBA and Custom Forms 45
M Setting flag follow up for next business day Outlook VBA and Custom Forms 1
D Next Available Meeting with Userform Variables Outlook VBA and Custom Forms 1
F Set (flagged) reminder for next business day Using Outlook 4
X Delay sending an email until the next working day (public holidays) Outlook VBA and Custom Forms 0
S set a flag task date as the next weekday Outlook VBA and Custom Forms 4
M Change default "automatically test account settings when Next is clicked" Using Outlook 1
Connie Boyer Exporting Outlook calendar/find next repeating meeting Using Outlook 3
P How to save sent mail and forward it the next day Exchange Server Administration 3
M what's next after Outlook? Using Outlook 9
S Outlook 2010: Message Rules come back next time I restart Outlook Using Outlook 0
B Need help adding an image next to the Month Name in the header. Calendar Printing Assistant 1
J Print next 7 days view of calendar (2010) Using Outlook 3
E Next five calendar days Calendar Printing Assistant 2
P Task view - due next 21 days Using Outlook 1
A Custom form - hitting 'next item' button hangs Outlook Outlook VBA and Custom Forms 2
A how to capture events for next item Outlook VBA and Custom Forms 10
T Next Item & Previous Item Events Outlook VBA and Custom Forms 1
G Arggh, weakness of reminder for every Task recurrence Using Outlook 0
W Recurrence: delete older occurrences / change earliest start time Outlook VBA and Custom Forms 0
JoeG Appointment Delete/Change Recurrence Outlook VBA and Custom Forms 0
A Custom form not showing when recurrence is set for a meeting Using Outlook 0
C Find all deleted recurrence appointments Outlook VBA and Custom Forms 4
skylark53 Advanced recurrence problem Using Outlook 2
M Clear custom date field after recurrence Outlook VBA and Custom Forms 0
M Recurrence and custom fields Outlook VBA and Custom Forms 0
Commander1 Task Recurrence Settings Using Outlook 3
Jennifer Murphy Regenerate recurrence not working Using Outlook 3
Commodore Recurrence for N times, and one gets cancelled Using Outlook 3
A Appointment recurrence reset to 'end after 25 occurrences' Using Outlook 1
A Reminder for an overdue task with recurrence is disabled without user’ Outlook Wishlist 4
J Outlook Appointment recurrence setting Outlook VBA and Custom Forms 4
H Creating yearly recurrence appointment Outlook VBA and Custom Forms 5
H Creating recurrence appointment Outlook VBA and Custom Forms 2
W Change Start Time in Recurrence of an Appointment Outlook VBA and Custom Forms 2
V Get selected option in recurrence range group Outlook VBA and Custom Forms 4

Similar threads

Top