Question Locked
Using an Sql query to update a date field in Access results in a US date
0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I need to insert a date into a date field in access using VBA code, but when I do, it converts to US Format - i.e. 4th October turns into 10th April. All settings on my PC is in Aus locale. I have read posts about other users having this problem but I cannot find a specific article on how to get around this - Can you help me ??