Click to See Complete Forum and Search --> : IsNumeric/IsDate on French XP


Toot
January 31st, 2005, 05:27 AM
Hi again.

In an English culture, I would expect IsNumeric("1.212,3") to return False, and it does. Moving onto a French culture, I would expect it to return True (as that is how that culture writes numbers), but it doesn't. Further, IsDate("1.212,3") returns True (parses to 03-Jan-0212) when running under either culture (though both built in an English culture). Is this a bug? Do I need to do something before calling them in order to take note of the culture I'm running under?

Any comments appreciated,
T

asSiDeluxE!
February 1st, 2005, 04:14 PM
I always thought that by using IsNumeric() every single character is checked and not the whole string as a number. "," and "." are not numbers so that would explain why it returns "false" in french environment.
It's also possible that only the decimal separator is allowed, so that if you ommited the "." it would return "true"

No answer for the IsDate()-concerns...

Boumxyz2
February 2nd, 2005, 09:45 AM
take out the dot and the isnumeric should return true in french.. There's no . as a thousand delimiter in french ( Well not that I'm aware of at least ).