#1
|
|||
|
|||
Default dates for a Date Picker
I am currently creating a template document that includes the "Date Picker" field.
I have three fields in particular that need to have different dates in them, I am able to get the first one to work as it is for today's date. .DTPicker1.Value = Date However, the next two need to be 1 month and 6 months from the date the form is run. Do you have any ideas as to how I can go about this? |
#2
|
|||
|
|||
Try DatePicker2.Value = DateAdd("M", 1, Now") and
DatePicker3.Value = DateAdd("M", 6, Now") |
#3
|
|||
|
|||
Thank you gmaxey, that has worked.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro to DT Picker, but default to Weekdays | ofair | Word VBA | 1 | 05-21-2013 03:07 PM |
Date Picker | Andy2011 | Word VBA | 4 | 11-24-2012 10:07 PM |
Date picker mail merge error. | dan1 | Mail Merge | 7 | 06-28-2012 03:00 AM |
word 2003 date picker | nashville | Word | 16 | 04-06-2012 04:12 AM |
Date picker | trintukaz | Excel | 0 | 12-30-2011 12:42 AM |