Calculating age of something from a Date Picker

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

#11

01-10-2014, 05:29 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

D'oh, I thought I'd got this sorted, but unfortunately, the calculation appears to be giving out the wrong age

The line of code is:

Code:

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

Where

Frustratingly the output is showing as 21, rather than 20.

Does anyone have any ideas?

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:42 PM.