![]() |
#1
|
|||
|
|||
![]() 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.
|
![]() |
Thread Tools | |
Display Modes | |
|
![]() |
||||
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 |
![]() |
Andy2011 | Word VBA | 4 | 11-24-2012 10:07 PM |
![]() |
dan1 | Mail Merge | 7 | 06-28-2012 03:00 AM |
![]() |
nashville | Word | 16 | 04-06-2012 04:12 AM |
Date picker | trintukaz | Excel | 0 | 12-30-2011 12:42 AM |