Date format on UserForm changes on Spreadsheet

Hello

Users need to be able to enter a date into a TextBox on a UserForm in the Format DD-MM-YYYY.

This is then converted once entered into the format YYYY-MM-DD and when the SAVE button is selected, this is written to the spreadsheet.

The issue I am having is that the value written to the spreadsheet does not return the date in the required format of YYYY-MM-DD.

My code is below:

Code to check if DOB completed:

Please Login or Register  to view this content.

Code to convert entered date to YYYY-MM-DD format

Please Login or Register  to view this content.

Code to write DOB textbox to spreadsheet

Please Login or Register  to view this content.

thanks for any help.

Try:

Please Login or Register  to view this content.

Also check the cell format so it reflects "yyyy-mm-dd".

Sorry, double posted for some reason.

Admin - please delete this 2nd post.