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
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