VBA Dates in correct format (dd/mm/yyyy) on form but incorrect when inserted to worksheet?

Hi Everyone,

I'm sure that this is something simple that I am doing wrong but it is driving me to distraction.

I have a form on which I select a date (using a calendar form) and on the form it works perfectly. The date is in the correct dd/mm/yyyy format for example (03/04/2013 - 3rd April 2013), I then insert this date into a worksheet and it comes out in the correct format, but it is actually turning the dates around so where it should be putting 3rd of April (03/04/2013), it's inserting 4th March (04/03/2013) instead. It looks very much like the form sees the date in dd/mm/yyyy format and the worksheet when taking the data from the form thinks it in US format (mm/dd/yyyy).

This renders it completely useless. I have posted part of my code below, please help me understand what mistake I am making.

Please Login or Register  to view this content.

Assume this won't be the issue, but is your MS Office setup as UK country for default date, time format in Control Panel? (Tends to default to US date formats and languages).

Also can see from the code you're referencing a network(?) drive R:\...is that server setup as English UK?

Assume this won't be the issue, but is your MS Office setup as UK country for default date, time format in Control Panel? (Tends to default to US date formats and languages).

Also can see from the code you're referencing a network(?) drive R:\...is that server setup as English UK?

Assume this won't be the issue, but is your MS Office setup as UK country for default date, time format in Control Panel? (Tends to default to US date formats and languages).

Also can see from the code you're referencing a network(?) drive R:\...is that server setup as English UK?

Try

Please Login or Register  to view this content.

Hey Coreytroy.

Thx for det fix. It worked well for me..