PC Review


Reply
Thread Tools Rate Thread

How do I calculate the next recurrence date?

 
 
Warren Gamley
Guest
Posts: n/a
 
      26th Jul 2009
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?
 
Reply With Quote
 
 
 
 
Dmitry Streblechenko
Guest
Posts: n/a
 
      29th Jul 2009
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/rd...ncepattern.htm </plug>

--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
"Warren Gamley" <Warren (E-Mail Removed)> wrote in message
news:6214BA78-330B-4FD1-A9ED-(E-Mail Removed)...
>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?



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
add random date to recurrence curvcerv Microsoft Outlook Calendar 1 21st Mar 2009 02:02 AM
calculate recurrence of an appointment? dust.wind.dude@gmail.com Microsoft Outlook VBA Programming 2 27th Dec 2006 04:44 PM
Date Recurrence 2 =?Utf-8?B?RG91Zw==?= Microsoft Access Queries 1 24th Aug 2006 03:45 PM
Date Recurrence =?Utf-8?B?RG91Zw==?= Microsoft Access Queries 1 23rd Aug 2006 05:07 PM
Re: holidays recurrence date Vince Averello [MVP-Outlook] Microsoft Outlook Calendar 0 27th Aug 2003 01:28 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:15 AM.