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,543
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
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