Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-10-2013, 01:26 AM
BoringDavid BoringDavid is offline Default dates for a Date Picker Windows XP Default dates for a Date Picker Office 2007
Novice
Default dates for a Date Picker
 
Join Date: Sep 2013
Posts: 19
BoringDavid is on a distinguished road
Post 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?
Reply With Quote
  #2  
Old 09-10-2013, 12:54 PM
gmaxey gmaxey is offline Default dates for a Date Picker Windows 7 32bit Default dates for a Date Picker Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,601
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default

Try DatePicker2.Value = DateAdd("M", 1, Now") and
DatePicker3.Value = DateAdd("M", 6, Now")
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
  #3  
Old 09-11-2013, 01:42 AM
BoringDavid BoringDavid is offline Default dates for a Date Picker Windows XP Default dates for a Date Picker Office 2010 32bit
Novice
Default dates for a Date Picker
 
Join Date: Sep 2013
Posts: 19
BoringDavid is on a distinguished road
Default

Quote:
Originally Posted by gmaxey View Post
Try DatePicker2.Value = DateAdd("M", 1, Now") and
DatePicker3.Value = DateAdd("M", 6, Now")
Thank you gmaxey, that has worked.
Reply With Quote
Reply

Thread Tools
Display Modes


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
Default dates for a Date Picker Date Picker Andy2011 Word VBA 4 11-24-2012 10:07 PM
Default dates for a Date Picker Date picker mail merge error. dan1 Mail Merge 7 06-28-2012 03:00 AM
Default dates for a Date Picker word 2003 date picker nashville Word 16 04-06-2012 04:12 AM
Date picker trintukaz Excel 0 12-30-2011 12:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:16 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft