Calculating age of something from a Date Picker

		Microsoft Office Forums > Microsoft Word > Word VBA
Calculating age of something from a Date Picker

#12

01-10-2014, 03:02 PM

macropod

Windows 7 32bit Calculating age of something from a Date Picker

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,340

That's because your second date is in the 21st year after the first date. Try using:

Code:

c = DateDiff("yyyy", DTPStartDate.Value, Date) - 1

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Default dates for a Date Picker	BoringDavid	Word VBA	2	09-11-2013 01:42 AM
Date Picker	Andy2011	Word VBA	4	11-24-2012 10:07 PM
word 2003 date picker	nashville	Word	16	04-06-2012 04:12 AM
Date picker	trintukaz	Excel	0	12-30-2011 12:42 AM
Calculating age at date	jamierbooth	Excel	2	02-22-2011 03:35 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:07 AM.