March 19, 2001 03:19 PM

More Fun with Dates

Rating: (0)
Sue Mosher
Windows IT Pro
InstantDoc ID #20078
All my 2001 Outlook VBA on Demand columns have focused on date handling in Microsoft Outlook. The subject is popular—my Inbox and the Outlook newsgroups have recently been swamped with questions about using dates. Therefore, by popular demand, in this column I show you how to build a few more date procedures.

Th...

ARTICLE TOOLS

Want to use this article? Click here for options!

You must be a paid Professional Member to access this entire article.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Monthly or Annual

Professional Membership

VIP Membership

Compare Member Benefits

Add a Comment

Is there a function available for outlook to calculate "networkdays" without inserting an Excel spreadsheet into the form?

I am trying to perfect a Vacation Request form to discount weekends but can only find the formula in Excel.

Mark B10/21/2004 8:20:33 AM

Check out this tutorial:

http://www.321books.co.uk/ebooks/outlook-vba-tutorial.htm



mal4mac9/17/2004 3:50:14 AM

Kevin, Outlook provides no way to set the cursor position.

Sue Mosher 3/3/2004 7:56:23 AM

I just read your "More Fun with Dates" article and followed your instructions on Listing 3. How do I get the cursor to position at the end of the date stamp or on the line below. Currently the cursor returns to the upper left.

Kevin Herman 1/15/2002 5:07:00 PM

1. Quarter of an hour is 15 minutes - rounding to the nearest multiple of 4 minutes will *not* round to quarter of an hour!
2. Using CDate(Month & "/" & Day & "/" & Year) will only work on a US system. Use DateSerial(Year,Month,Day) instead.

richard7/19/2001 2:23:49 AM

You must log on before posting a comment.

Are you a new visitor? Register Here

Related Resources

PrimalScript 2009: TFM®
A EBook by Sapien
The Top 8 Challenges to Exchange High Availability and Disaster Recovery
A Tip Guide by CA/ARCserve
Understanding and Leveraging Code Signing Technologies
A EBook by Thawte Consulting
Keep Your Email Flowing
A Podcast by AppAssure Software
More

windows server 2008 login scripts

I have 2 win2k8 servers one pdc and bdc. The domain is exampledom.com They are connected to 2 iscsi luns which replicate each other. We are running ac...222-96118

advertisement

GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS

White Papers

Your remote offices contain valuable electronic data – are they adequately protected? Learn how proven technologies can reliably and cost-effectively back up a branch office from a central location, in real time, to disk or tape, and even utilize existing backup solutions.

Downloads

PacketTrap IT is a comprehensive and affordable network management and application monitoring solution that solves problems associated with bandwidth, network and application performance, and connectivity. Gain insight into your network - try PacketTrapIT free for 21 days!

Web Seminars

IT administrators have to solve a myriad of problems. This web seminar outlines the ten most common systems management pains - including managing highly distributed systems and dealing with data theft/loss – and the best practices to address each.

eLearning Series

We bring the experts direct to you to share their real-world perspective and expertise. During each event, three sessions stream in real time, so you can learn, ask questions, and get solutions.
Upcoming event: Getting the Most with Exchange 2010 with Paul Robichaux

Subscribe to Windows IT Pro!

DevProConnections ITTV Left-Brain SharePointPro Connections SQL Server Magazine SuperSite for Windows Windows IT Pro

© Penton Media, Inc.

Home About Us Advertise Customer Service Privacy Statement Subscribe/Renew Terms Of Use

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.