• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 752
  • Last Modified:

Adding a Reminder Time Via Vbscript to outlook

I have a solution for adding the due date at this post: http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_25025125.html?cid=748#a26194480

Now I want to do the same thing but add a reminder time: The data I get from the accounting software is like 20100106

I am using the above link formula to covert to outlook time but how do I also add a time to that. The time I wan't to add will always be 10:00 AM

Here is the reminder time code that works:

reminderTime = dateserial(left("20100108",4),mid("20100108", 5, 2),mid("20100108",7,2))

Now I wan't to add the 10:00AM somehow

Thanks
0
badgermike
Asked:
badgermike
1 Solution
 
badgermikeAuthor Commented:
In my 3rd sentance, I meant I am using the above link to convert the date (not time)...I just want to add 10:00am to it.

0
 
Chris BottomleySoftware Quality Lead EngineerCommented:
Hello badgermike,

Do you mean:

dateserial(left("20100108",4),mid("20100108", 5, 2),mid("20100108",7,2)) + timevalue("10:00") or
Format(dateserial(left("20100108",4),mid("20100108", 5, 2),mid("20100108",7,2)) + timevalue("10:10"), "ddddd h:nn AMPM")

Regards,

chris_bottomley
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now