problem function date add into datepicker on userform

[abdelfattah]

hi
i have problem add years and months days is ok i have textbox1= days textbox2= months textbox3= years when i choose in datepicker1= date then add months an years to datepicker2
this is my simple code

Private Sub CommandButton2_Click()
    datepicker2 = DateAdd("d", textbox1.Text, datepicker1)
     datepicker2 = DateAdd("M", textbox2.Text, datepicker1)
      datepicker2 = DateAdd("YYYY", textbox3.Text, datepicker1)
End Sub

 

[DanteAmor]

Sorry, the correct code is this:

Private Sub CommandButton1_Click()
'Account OLD
  TextBox3.Value = CDate(TextBox2.Value) - CDate(TextBox1.Value)
End Sub

Private Sub CommandButton2_Click()
'Account Date
  datepicker2 = datepicker1 + (CDate(TextBox2.Value) - CDate(TextBox1.Value))
End Sub

 

[Rick Rothstein]

Any system for counting years and months will inevitably have differences due to the variable length of months.
In my opinion, it is impossible to get a completely "accurate" result by measuring date differences in this way.
I recommend you only get a textbox (3) to get the total days.
Delete textbox 4 and 5,

I agree !!!

 

[abdelfattah]

thanks your both Dante,Rick it's better than before i would thank you for every all your support and i apology if my subject not clear from the beginning it takes more time to solve me problem this is because of me don't make clear from the beginning more again thanks for your patience and time
god bless you

 

[Fluff]

Cross posted with no links yet again.

Please supply the link(s).

 

[abdelfattah]

hi, fluff but i issue this post first in this forum and i informed another forum about solving as you like


help fix dateadd into ditpicker on userform [SOLVED]

 

[Fluff]

I don't care where you posted first, WHENEVER you cross post you MUST supply the link(s).

 

[abdelfattah]

but as far as i know when you ask the link to don't waste time the members if the post solved in specific forum and don't inform the members about the solve , right ?

 

[Fluff]

WRONG. You need to supply link(s) WHENEVER you cross post. Not just when you feel like it.
You have already been directed to this site on more then one occasion. I would suggest you read it.

A message to forum cross posters

Do you know why you're here? If you have been pointed to this page, it is not because someone is mad at you, but rather because we want to curb your posting habits before people start ignoring your posts. Online … Continue reading →

www.excelguru.ca

 

[DanteAmor]

thanks your both Dante,Rick it's better than before i would thank you for every all your support

Glad we could help & thanks for the feedback