Microsoft Office Forums - View Single Post - [Solved] Calculating age of something from a Date Picker

Thread: [Solved] Calculating age of something from a Date Picker

View Single Post

Old

01-13-2014, 02:40 AM

BoringDavid BoringDavid is offline

BoringDavid is offline

BoringDavid uses Windows XP

Windows XP BoringDavid uses Office 2010 32bit

BoringDavid uses Office 2010 32bit

Office 2010 32bit

Novice

The original poster

Join Date: Sep 2013

Posts: 19

BoringDavid is on a distinguished road

Default

Quote:

Originally Posted by macropod

View Post

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.

Reply With Quote