Convert Date 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 the string date he filled to yyyy-mm-dd regarding this format ?



Help Please !

.

Relevant Pages

  • Re: text date to date format
    ... Then just 1- choose a date format YYYY-MM-DD in the cell ... OR 2- convert it again to a new string in the new format with the ...
    (microsoft.public.excel.misc)
  • 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)
  • Re: get ResponseCode() and connect()
    ... connect then get the response code of the remote server. ... URL url = new URL; ... String name = uc.getHeaderFieldKey; ...
    (comp.lang.java.programmer)
  • Accessing files and folders on remote server - SERVER ERROR
    ... This users has been created on the remote server, ... Cannot execute a program. ... An unhandled exception occurred during compilation using ... userToken, String cmd, String currentDir, TempFileCollection tempFiles, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Impersonation causes a server error
    ... This users has been created on the remote server, ... Cannot execute a program. ... An unhandled exception occurred during compilation using ... userToken, String cmd, String currentDir, TempFileCollection tempFiles, ...
    (microsoft.public.dotnet.languages.csharp)