userform text boxes for dates

[Mattlake]

Hi

I don't want to keep asking stupid questions but the internet seems not to know the answer (or I am asking it the wrong way).

I have 2 text boxes that show the dates (Text_datefrom and Text_dateto) and when I press a command button it works out the difference.

The issue I think I am having is that the date is showing in mmddyyyy and i need it in ddmmyyyy so when i put 2 dates in 30/09/2019 and 4/10/2019 it should be 5 days not -172

when it transfers to the spreadsheet it seems to know that it is ddmmyyyy as it then formats into ddmmmyy

does this make sense?

Regards

Matthew

 

[Mattlake]

sorry don't worry about this found the solution with

Private Sub text_datefrom_AfterUpdate()
On Error Resume Next
Me.Text_datefrom = CDate(Me.Text_datefrom)
Me.Text_datefrom = Format(Text_datefrom.Text, "dd-mm-yyyy")
End Sub

Private Sub text_dateto_AfterUpdate()
On Error Resume Next
Me.Text_dateto = CDate(Me.Text_dateto)
Me.Text_dateto = Format(Text_dateto.Text, "dd-mm-yyyy")
End Sub