View Single Post
 
Old 01-10-2014, 03:02 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,862
macropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud of
Default

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
[MS MVP - Word]
Reply With Quote