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?

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/

Thank you gmaxey, that has worked.