dates issue (1 Viewer)

bigmac

Registered User.
Local time
Today, 08:34
Joined
Oct 5, 2008
Messages
295
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 :confused:
 

Ranman256

Well-known member
Local time
Today, 11:34
Joined
Apr 9, 2015
Messages
4,339
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

Registered User.
Local time
Today, 08:34
Joined
Oct 5, 2008
Messages
295
thank you ranman356 , works a treat :)
 

Users who are viewing this thread

Top Bottom