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?