Calculating age of something from a Date Picker

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

#13

01-13-2014, 02:40 AM

BoringDavid BoringDavid is offline

Windows XP Calculating age of something from a Date Picker

Office 2010 32bit

Novice

Join Date: Sep 2013

Posts: 19

Quote:

Originally Posted by macropod

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

Thank you that has corrected the code.

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 09:18 AM.