View Single Post
Old 10-18-2013, 02:20 AM
BoringDavid BoringDavid is offline Windows XP Office 2010 32bit
Join Date: Sep 2013
Posts: 19
BoringDavid is on a distinguished road

Originally Posted by macropod View Post
Surely you can at least post a bare document containing a userform with whatever date-picker are you using?
I'm unable to upload anything I'm afraid, however, I can confirm the Date Picker is the standard Date Picker used in Word 2010, it is the only one I am aware of and is selected from the toolbox (once I'd selected it from the additional commands).

I have tried another method to no avail...

Dim StartDate, StartYear
StartDate = Me.DTPStartDate
StartYear = Year(StartDate)

Dim TodayDate, TodayYear
TodayDate = Date
TodayYear = Year(TodayDate)

c = DateAdd(yyyy, -StartYear, TodayYear)
Reply With Quote