Dates are transposed using fill in form

[fastcar]

Hi All,

I am using this VBA code to get data from a fill in form to populate a table.

Please Login or Register  to view this content.

This populates the sheet fine except row P,Q,S and U. These are all dates.

When I enter the date in the fill in form for example 11/09/2017 it will change it to 09/11/2017 on the sheet if the column is formatted as date, but if it is formatted as text it will stay as 11/09/2017.

I tried this.

Please Login or Register  to view this content.

But still the same.

Thanks

[gfranco]

Good afternoon.
I usually use the value2 property of the range object when the data type is date.
See if the attachment helps you

[fastcar]

Good afternoon.
I usually use the value2 property of the range object when the data type is date.
See if the attachment helps you

Thanks for the reply.
I see that imports the info from the sheet to the form but my issue is the other way round. I type the date in the form but it does not write it correctly on the sheet, it I type 11/09/2017 on the form it writes 09/11/2017 on the worksheet.

Cheers.

[fastcar]

To make things easier I have added the file here.

If you click "Update Edit - Driver Details" on the "Menu" sheet it brings up a fill in form, if you select driver B for example then click "find details" it will pull up his details
fine, but when you click "Update details" and then "Find Details" again the DD and MM of the date keep getting transposed.

I have formatted the columns as Date.

Thanks for the help.

[bakerman2]

How about this ?

Please Login or Register  to view this content.

PS your Column U is formatted as Text.

[gfranco]

Good evening.
Here with me it worked perfectly, but I noticed that some dates were formatted as text in your spreadsheet. In doubt, I've formatted all columns of entire dates as date and it's working fine here with me. My default date system is DD / MM / YYYY

[fastcar]

How about this ?

Please Login or Register  to view this content.

PS your Column U is formatted as Text.

Thanks worked fine.