Solved

VBA adding appointment to Outlook calendar subtracting 1 day from end date

Posted on 2011-03-11
4
537 Views
Last Modified: 2013-11-27
I'm not sure if I can still ask a question here of if I'm supposed to start a new thread...sorry I'm a newbie.  

The problem I'm having is when the vacation request is for multiple days...say 3/2/2011 to 3/7/2011.  It goes into the calendar but subtracts a day from the end date.  So in the calendar it shows the vaca as 3/2/2011 to 3/6/2011.  Is there a correct way to fix this?  
0
Comment
Question by:AronMcD
  • 2
4 Comments
 
LVL 14

Accepted Solution

by:
pteranodon72 earned 500 total points
ID: 35109814
You don't show any code, so we are in the dark. My shot in the dark is:

If you specify only a date value, the time is assumed to be midnight. So, a vacation from midnight 3/2/2011 to midnight 3/7/2011 would mean that 3/7/2011 8:00 AM should be post-vacation. Add one day to the end date to move the end to midnight of the day of return.

Hope this helps,
pT72
0
 

Author Comment

by:AronMcD
ID: 35109855
Thanks pteranodon72.  I kind of figured that may be whats happening.  I can't just add a day to the end date as there are sometimes vacation requests for just one day ie: Start Date - 3/2/2011 to End Date - 3/2/2011.  Will have to do a check before adding the day?  If so, how would be the best way to do so?  Or is there another way?

Thanks again.
0
 
LVL 59

Expert Comment

by:Chris Bottomley
ID: 35110099
Can you give some examples as to what you have in your Db for me.startdate and me.enddate,  i.e for 1 and multiple day entries?

Chris
0
 

Author Comment

by:AronMcD
ID: 35110614
I ended up doing a check on the start date and end date.  If the end date was different than the start date I added a day.  Seems to work fine.

Thanks guys for the help.  
0

Featured Post

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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Multiple SSL on Exchange 2010 3 28
VBA SQL statement - 2 "OR"s and 1 "And" 4 27
outlook 6 40
Dcount help 2 16
This process describes the steps required to Import and Export data from and to .pst files using Exchange 2010. We can use these steps to export data from a user to a .pst file, import data back to the same or a different user, or even import data t…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
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…

777 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