I have a VB6 application that manages dates in many ways and one of my customers likes to use a period (".") as date separator in its regional settings. The glitch is that it does not seem to be supported by VB since when I use a period as date separator and I call...

IsDate(Format(Now))
- or -
IsDate("01.01.2000")

...it always return False. And when I call...

CDate(Format(Now))
- or -
CDate("01.01.2000")

...it gives me a run-time 13 (Type Mismatch).

Even if I use other separators for decimal and thousand, it keeps failing.

Anybody has ever heard of this? If so, does somebody have a solution?

My application is quite big and I am affraid workarounds would not solve my problem.

Thanks in advance,
Tipi