dates issue

[bigmac]

hello all can you help please i have a text box [six month update] this uses a date picker to populate it , what i want is after update to add 6 months to the value in the [six month update]text box ,
i have tried
Me.SIX_month_update = DateAdd("m", 6, Date)
but it keeps coming up with 06/09/19 even if i pick a different date with the date picker, any ideas please

 

[Ranman256]

you have the wrong parameter, Not current date(), use the textbox value

=DateAdd("m", 6,Me.MyDate)

(unless you want 6 mos from current date, then Date() is correct)

 

[bigmac]

thank you ranman356 , works a treat