My Query reads some dates as American dates?

The backslashes are "literal escapes", meaning that the subsequent character is to be interpreted exactly as typed. The backslash before the hash is fairly obvious but the one before the forward slashes deserves some explanation.

A forward slash in a format string is actually a placeholder for the regional date separator. In many regions this separator is the forward slash so the escape is not essential. However including it ensures that the format will work in all regions.

Many thanks for this explanation
I'm wondering where else I can use the same idea
 

Users who are viewing this thread

Back
Top Bottom