isladogs
MVP / VIP
- Local time
- Today, 17:11
- Joined
- Jan 14, 2017
- Messages
- 18,788
Not quite correct.
There are two universal date formats that can be used in VBA: mm/dd/yyyy and yyyy-mm-dd
In the UK we use dd/mm/yyyy which has to be converted in VBA for reliable results.
Dates like 17/02/2020 cannot be misinterpreted as anything other than 17 Feb 2020
However a date like 10/02/2020 could be 10 Feb or 2 Oct.
Access will assume the latter which in the UK will cause issues
Good luck with the rest of your project
There are two universal date formats that can be used in VBA: mm/dd/yyyy and yyyy-mm-dd
In the UK we use dd/mm/yyyy which has to be converted in VBA for reliable results.
Dates like 17/02/2020 cannot be misinterpreted as anything other than 17 Feb 2020
However a date like 10/02/2020 could be 10 Feb or 2 Oct.
Access will assume the latter which in the UK will cause issues
Good luck with the rest of your project