Get ALL date formats from regional setting
Working with VBA and dates outside the US is a nightmare, and we never know when we are going to get the right date or not. Most of Access handles dates OK, but VBA is inconsistent.
Typically much of the rest of the world gets the worst of it.
If we put in
01/07/2016, it becomes January 7th not 1st of July
12/07/2016 is treated as December 7th not 12thJuly
15/07/2016 is treated as 15th July,
This is NOT helpful.
Can we have the ability to get VBA to use the regional settings for date formats.
Or at least throw an error with 15/07/2016?
Date managing is KEY to so many applications, and having VBA switching between one format and another, really is irritating.