Solved

Create recurring appointment 2nd last work day of each month

Posted on 2006-07-18
9
2,008 Views
Last Modified: 2016-09-28
Hi

I would like to create a recurring appointment on the second last work day of each month.

How can I do this?

Thanks
0
Comment
Question by:kylet13
  • 2
  • 2
  • 2
  • +1
9 Comments
 
LVL 7

Expert Comment

by:MontyV
ID: 17132826
Do you mean the second to last day?  For example the last work day for this month is (assuming M-F schedule) is Monday July 31st, so you want the Friday July 28th to come up?

- Monty
0
 

Author Comment

by:kylet13
ID: 17140380
Hi Monty

Yes.  You are correct.  I should have said "last week day of the month".

-Kyle
0
 
LVL 7

Accepted Solution

by:
MontyV earned 500 total points
ID: 17140409
Well I know there is no built in way of doing this.  I'm assuming maybe the VBA guys can help which means I am of now help :(  You can easily set it for the last weekday of the month though and some other simiiar combinations.  Sorry I can help further.

- Monty
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

Author Comment

by:kylet13
ID: 17578998
I do not accept MontyV's answer.  

Although friendly, it did not answer the question.  I have not found a solution to this problem.  

Kyle
0
 
LVL 20

Expert Comment

by:Venabili
ID: 17580208
There is no built in way. This is the answer no matter if you like it or not....
0
 

Expert Comment

by:dobi goth
ID: 41819451
Hi Kyle,

Actually there's answer to this question, You can set the recurrence to the last day and then in the reminders, select 1 day before.
0
 

Expert Comment

by:dobi goth
ID: 41819452
Hi Kyle,

Actually there's answer to this question, You can set the recurrence to the last day and then in the reminders, select 1 day before.

Dobigoth
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Follow this checklist to learn more about the 15 things you should never include in an email signature from personal quotes, animated gifs and out-of-date marketing content.
Many people use more than one email account and so it becomes difficult for them to manage them when they use separate accounts,  so, in this article, I have shared an easy way to add Other Mail Accounts in your Google Inbox. It helps to combine all…
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now