[Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 745
  • 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

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.

Chris BottomleyCommented:
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")



Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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