Date conversion pb

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 date regarding this format ?

Help Please !

.

Relevant Pages

  • Re: format of service principal name (SPN)
    ... credentials to a remote server fails because the remote server receives the ... We need to set up the service principal name for a service in this format ... we use object guid what format do we enter that? ...
    (microsoft.public.windows.server.security)
  • Convert Date pb
    ... The remote server has regional settings set to "en-UK" and date to ... the following format yyyy-mm-dd. ... convert the string date he filled to yyyy-mm-dd regarding this format? ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: How to programmatically refresh linked tables
    ... comes into existance -- this product info is pulled from another ... When new products come into existance in the remote ... Would it be correct to assume that the format of the new tables ...
    (comp.databases.ms-access)
  • Re: English (UK) Settings Problem?
    ... has his regional settings set to U.K. and office language set to English ... this workbook has a column with dates. ... formula's that need this mmm-yyyy format. ... it does not apparently work for the customer. ...
    (microsoft.public.excel.programming)
  • Re: Phone Number format
    ... ie I can format phone numbers any way I like. ... > Have you checked that you have the correct country set ... Regional Settings set to English. ... Tick the box to display it on startup if that is what you want. ...
    (microsoft.public.pocketpc)