469,946 Members | 1,999 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,946 developers. It's quick & easy.

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 !

Nov 17 '05 #1
2 4847

"Franck" <we**********@gmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
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 !


Given a date, you can try DateTime.Parse to return a date...

Let us know how it goes! :)

Mythran

Nov 17 '05 #2
The point is that I can figure out how the user filled the date...
All case worked with a Convert.ToDateTime.

31/12/2005 -> OK
31/12/05 -> OK
12/31/2005 -> OK
12/31/05 -> OK
BUT, when the user send an "ambiguous" date (5/1/2005 could be 5th of
Jan or 1st of May regarding regional date settings) here is
nightmare... If the user is in M/d/yyyy, the Convert.ToDateTime
convert in dd/MM/yyyy

SO, I'm trying to know user's date regional settings in order to make
the correct Date.Parse.

Help :(

"Mythran" <ki********@hotmail.comREMOVETRAIL> wrote in message news:<eJ*************@TK2MSFTNGP15.phx.gbl>...
"Franck" <we**********@gmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
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 !


Given a date, you can try DateTime.Parse to return a date...

Let us know how it goes! :)

Mythran

Nov 17 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

19 posts views Thread by Lauren Quantrell | last post: by
4 posts views Thread by Richard Hollenbeck | last post: by
3 posts views Thread by jerry.ranch | last post: by
17 posts views Thread by Terry Jolly | last post: by
4 posts views Thread by perryclisbee via AccessMonster.com | last post: by
8 posts views Thread by deepak_kamath_n | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.