Hi,
'm gettin mad about date conversion.
Here is the point.
Got and add-in for Excel which call functions from a web service (on a
remote server)
The remote server has regional settings set to "en-UK" and date to
dd/MM/yyyy. (I'can't change it !)
One of my function get a string as parameter and convert it to date in
the following format yyyy-mm-dd.
So, Having regional settings set to "fr-ch" (date format dd.mm.yyyy), I
call my function with "31/10/2003"... Works grate (with every date).
Changing regional settings to "en-US" and date to default "M/d/yyyy",
the function do not recognize the date.
I tried to set CurrentThread culture to a specific one, I tried
Date.Parse... I must miss somethin...
Is there a way to get back client date format during request and
convert the string date he filled to yyyy-mm-dd regarding this format ?
Help Please !