text date conversion

Hi peeps
I have a datepicker control that's providing dates in the format dd/mm/yyyy
(UK).
I want to convert this to "yyyy-mm-dd" to store as a text field in my
database (had lots of problems with date conversions using "proper" data
fields).
I used to use ASP, and it was easy, using a combination of Left() Mid() and
Right(), but I can't work out how to do this conversion in C#.
Help appreciated!
Cheers
DanDateTime.ToString("yyyy-MM-dd");
"dhnriverside" <dan@.musoswire.com> wrote in message
news:F96893C8-D39B-4207-B3C9-861A42594CD5@.microsoft.com...
Hi peeps
I have a datepicker control that's providing dates in the format dd/mm/yyyy
(UK).
I want to convert this to "yyyy-mm-dd" to store as a text field in my
database (had lots of problems with date conversions using "proper" data
fields).
I used to use ASP, and it was easy, using a combination of Left() Mid() and
Right(), but I can't work out how to do this conversion in C#.
Help appreciated!
Cheers
Dan
Easy,
Split the string "mm/dd/yyyy" into an array using the delimiter "/" so that
you get:
[mm]
[dd]
[yyyy]
Then swap array positions so you get:
[yyyy]
[mm]
[dd]
Then join the array using the "-" character.
Why you would choose to store DATES as STRINGS is beyond me (just sounds
like a really, really newbie solution)...but if it floats your boat, then
there's your solution.
"dhnriverside" wrote:

> Hi peeps
> I have a datepicker control that's providing dates in the format dd/mm/yyy
y
> (UK).
> I want to convert this to "yyyy-mm-dd" to store as a text field in my
> database (had lots of problems with date conversions using "proper" data
> fields).
> I used to use ASP, and it was easy, using a combination of Left() Mid() an
d
> Right(), but I can't work out how to do this conversion in C#.
> Help appreciated!
> Cheers
>
> Dan
Hi Charles
Thanks for that. Yeah it was very newbie. The original system was written
with Access/ASP and as I said I had tremendous trouble with pulling dates ou
t
the database.
Sussed that now, but im writing V2, it's just easier to continue with this
system than converting allllll the data :o)
Cheers for the answer!
Dan
"Charles Chen" wrote:
> Easy,
> Split the string "mm/dd/yyyy" into an array using the delimiter "/" so tha
t
> you get:
> [mm]
> [dd]
> [yyyy]
> Then swap array positions so you get:
> [yyyy]
> [mm]
> [dd]
> Then join the array using the "-" character.
> Why you would choose to store DATES as STRINGS is beyond me (just sounds
> like a really, really newbie solution)...but if it floats your boat, then
> there's your solution.
> "dhnriverside" wrote:
>
Dan,
You could always use the build in formatting on the DateTime object.
string s = "25/12/2004"
DateTime d = DateTime.ParseExact( s, "d/M/yyyy", null );
Now the variable 'd' will hold the date exactly as Dec 25, 2004.
You can get the date back out in any format you want using the .ToString()
method.
Console.WriteLine( d.ToString( "yyyy-MM-dd" ) )
Here are a couple links for DateTime formatting. These are gem pages for
working with any DateTime formatting issues.
http://msdn.microsoft.com/library/d...rmatstrings.asp
http://msdn.microsoft.com/library/d...rmatstrings.asp
Happy formatting!
bill
"dhnriverside" <dan@.musoswire.com> wrote in message
news:F96893C8-D39B-4207-B3C9-861A42594CD5@.microsoft.com...
> Hi peeps
> I have a datepicker control that's providing dates in the format
dd/mm/yyyy
> (UK).
> I want to convert this to "yyyy-mm-dd" to store as a text field in my
> database (had lots of problems with date conversions using "proper" data
> fields).
> I used to use ASP, and it was easy, using a combination of Left() Mid()
and
> Right(), but I can't work out how to do this conversion in C#.
> Help appreciated!
> Cheers
>
> Dan

text date conversion

Hi peeps

I have a datepicker control that's providing dates in the format dd/mm/yyyy
(UK).

I want to convert this to "yyyy-mm-dd" to store as a text field in my
database (had lots of problems with date conversions using "proper" data
fields).

I used to use ASP, and it was easy, using a combination of Left() Mid() and
Right(), but I can't work out how to do this conversion in C#.

Help appreciated!

Cheers

DanDateTime.ToString("yyyy-MM-dd");

"dhnriverside" <dan@.musoswire.com> wrote in message
news:F96893C8-D39B-4207-B3C9-861A42594CD5@.microsoft.com...
Hi peeps

I have a datepicker control that's providing dates in the format dd/mm/yyyy
(UK).

I want to convert this to "yyyy-mm-dd" to store as a text field in my
database (had lots of problems with date conversions using "proper" data
fields).

I used to use ASP, and it was easy, using a combination of Left() Mid() and
Right(), but I can't work out how to do this conversion in C#.

Help appreciated!

Cheers

Dan
Easy,

Split the string "mm/dd/yyyy" into an array using the delimiter "/" so that
you get:

[mm]
[dd]
[yyyy]

Then swap array positions so you get:

[yyyy]
[mm]
[dd]

Then join the array using the "-" character.

Why you would choose to store DATES as STRINGS is beyond me (just sounds
like a really, really newbie solution)...but if it floats your boat, then
there's your solution.

"dhnriverside" wrote:

> Hi peeps
> I have a datepicker control that's providing dates in the format dd/mm/yyyy
> (UK).
> I want to convert this to "yyyy-mm-dd" to store as a text field in my
> database (had lots of problems with date conversions using "proper" data
> fields).
> I used to use ASP, and it was easy, using a combination of Left() Mid() and
> Right(), but I can't work out how to do this conversion in C#.
> Help appreciated!
> Cheers
>
> Dan
Hi Charles

Thanks for that. Yeah it was very newbie. The original system was written
with Access/ASP and as I said I had tremendous trouble with pulling dates out
the database.

Sussed that now, but im writing V2, it's just easier to continue with this
system than converting allllll the data :o)

Cheers for the answer!

Dan

"Charles Chen" wrote:

> Easy,
> Split the string "mm/dd/yyyy" into an array using the delimiter "/" so that
> you get:
> [mm]
> [dd]
> [yyyy]
> Then swap array positions so you get:
> [yyyy]
> [mm]
> [dd]
> Then join the array using the "-" character.
> Why you would choose to store DATES as STRINGS is beyond me (just sounds
> like a really, really newbie solution)...but if it floats your boat, then
> there's your solution.
> "dhnriverside" wrote:
> > Hi peeps
> > I have a datepicker control that's providing dates in the format dd/mm/yyyy
> > (UK).
> > I want to convert this to "yyyy-mm-dd" to store as a text field in my
> > database (had lots of problems with date conversions using "proper" data
> > fields).
> > I used to use ASP, and it was easy, using a combination of Left() Mid() and
> > Right(), but I can't work out how to do this conversion in C#.
> > Help appreciated!
> > Cheers
> > Dan
Dan,

You could always use the build in formatting on the DateTime object.

string s = "25/12/2004"
DateTime d = DateTime.ParseExact( s, "d/M/yyyy", null );

Now the variable 'd' will hold the date exactly as Dec 25, 2004.

You can get the date back out in any format you want using the .ToString()
method.

Console.WriteLine( d.ToString( "yyyy-MM-dd" ) )

Here are a couple links for DateTime formatting. These are gem pages for
working with any DateTime formatting issues.

http://msdn.microsoft.com/library/d...rmatstrings.asp
http://msdn.microsoft.com/library/d...rmatstrings.asp

Happy formatting!

bill

"dhnriverside" <dan@.musoswire.com> wrote in message
news:F96893C8-D39B-4207-B3C9-861A42594CD5@.microsoft.com...
> Hi peeps
> I have a datepicker control that's providing dates in the format
dd/mm/yyyy
> (UK).
> I want to convert this to "yyyy-mm-dd" to store as a text field in my
> database (had lots of problems with date conversions using "proper" data
> fields).
> I used to use ASP, and it was easy, using a combination of Left() Mid()
and
> Right(), but I can't work out how to do this conversion in C#.
> Help appreciated!
> Cheers
>
> Dan

Text Format String - Please help

Hi,

I need to display a DateTime field in 'mm/dd/yyyy' in a DataGrid.. On
myGrid1 - Properties - Columns - myColumn1 - Text format string:

I tried to put 'mm/dd/yyyy' in there and it displays 'mm/dd/yyyy' in stead
of '04/10/2001'. I know I didn't do it right. Please let me know what's the
correct way to display a 'mm/dd/yyyy' format for a DateTime coulmn.

Thanks.

Eddymake sure ur page Culture is set right
"Eddy Soeparmin" <esoeparmin@.clientprofiles.com> wrote in message
news:udPQR07RDHA.2008@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I need to display a DateTime field in 'mm/dd/yyyy' in a DataGrid.. On
> myGrid1 - Properties - Columns - myColumn1 - Text format string:
> I tried to put 'mm/dd/yyyy' in there and it displays 'mm/dd/yyyy' in stead
> of '04/10/2001'. I know I didn't do it right. Please let me know what's
the
> correct way to display a 'mm/dd/yyyy' format for a DateTime coulmn.
> Thanks.
> Eddy
Hi Vincent,

> make sure ur page Culture is set right
I don't really understand what you mean by that, would you please explain
more specific in detail? I'm very new in this area. Is there something that
I have to do in VS.Net? or IE? Please advice.

Thanks.

"Vincent V" <vincentv@.-n0-5pam-optushome.com.au> wrote in message
news:O6fD6H8RDHA.304@.tk2msftngp13.phx.gbl...
> make sure ur page Culture is set right
> "Eddy Soeparmin" <esoeparmin@.clientprofiles.com> wrote in message
> news:udPQR07RDHA.2008@.TK2MSFTNGP11.phx.gbl...
> > Hi,
> > I need to display a DateTime field in 'mm/dd/yyyy' in a DataGrid.. On
> > myGrid1 - Properties - Columns - myColumn1 - Text format string:
> > I tried to put 'mm/dd/yyyy' in there and it displays 'mm/dd/yyyy' in
stead
> > of '04/10/2001'. I know I didn't do it right. Please let me know what's
> the
> > correct way to display a 'mm/dd/yyyy' format for a DateTime coulmn.
> > Thanks.
> > Eddy
Eddy,

I found myself having this problem the other day and
couldn't find any documentation in the MSDN other than for
numbers. Here is what you need to put in the format
string:

{0:mm/dd/yyyy}

Also,

http://asp.net/ is a really good site for anything related
to ASP .NET or .NET in general. The people in the Forums
there are very helpful and usually can answer my questions
within an hour.

>--Original Message--
>Hi,
>I need to display a DateTime field in 'mm/dd/yyyy' in a
DataGrid.. On
>myGrid1 - Properties - Columns - myColumn1 - Text format
string:
>I tried to put 'mm/dd/yyyy' in there and it
displays 'mm/dd/yyyy' in stead
>of '04/10/2001'. I know I didn't do it right. Please let
me know what's the
>correct way to display a 'mm/dd/yyyy' format for a
DateTime coulmn.
>Thanks.
>Eddy
>
>.
Vincent,
Try using the format "{0:MM/dd/yyyy}". Also, check the Help section within
the DataGrid Property Builder dialog box. It will provide you with more
information about the format modifiers.

Charlie Nilsson [msft]
Visual Studio Update

--

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this
message are best directed to the newsgroup/thread from which they
originated.
-------
> From: "Eddy Soeparmin" <esoeparmin@.clientprofiles.com>
> Subject: Text Format String - Please help
> Date: Fri, 11 Jul 2003 11:03:09 -0400
> Lines: 14
> X-Priority: 3
> X-MSMail-Priority: Normal
> X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
> Message-ID: <udPQR07RDHA.2008@.TK2MSFTNGP11.phx.gbl>
> Newsgroups: microsoft.public.dotnet.framework.aspnet
> NNTP-Posting-Host: adsl-065-083-137-202.sip.asm.bellsouth.net
65.83.137.202
> Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP11.phx.gbl
> Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.aspnet:158558
> X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
> Hi,
> I need to display a DateTime field in 'mm/dd/yyyy' in a DataGrid.. On
> myGrid1 - Properties - Columns - myColumn1 - Text format string:
> I tried to put 'mm/dd/yyyy' in there and it displays 'mm/dd/yyyy' in stead
> of '04/10/2001'. I know I didn't do it right. Please let me know what's
the
> correct way to display a 'mm/dd/yyyy' format for a DateTime coulmn.
> Thanks.
> Eddy
Thanks Brian, Charlie,

When applying that format, it displays 00/09/1999 instead of 07/09/1999. I
will look at the http://asp.net/ and DataGrid Property Builder dialog box.

Eddy

"Charlie Nilsson [MSFT]" <CharlieNilsson_CUTOUT_@.hotmail.com> wrote in
message news:N6MXH28RDHA.1616@.cpmsftngxa06.phx.gbl...
> Vincent,
> Try using the format "{0:MM/dd/yyyy}". Also, check the Help section
within
> the DataGrid Property Builder dialog box. It will provide you with more
> information about the format modifiers.
> Charlie Nilsson [msft]
> Visual Studio Update
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> Note: For the benefit of the community-at-large, all responses to this
> message are best directed to the newsgroup/thread from which they
> originated.
> -------
> > From: "Eddy Soeparmin" <esoeparmin@.clientprofiles.com>
> > Subject: Text Format String - Please help
> > Date: Fri, 11 Jul 2003 11:03:09 -0400
> > Lines: 14
> > X-Priority: 3
> > X-MSMail-Priority: Normal
> > X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
> > X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
> > Message-ID: <udPQR07RDHA.2008@.TK2MSFTNGP11.phx.gbl>
> > Newsgroups: microsoft.public.dotnet.framework.aspnet
> > NNTP-Posting-Host: adsl-065-083-137-202.sip.asm.bellsouth.net
> 65.83.137.202
> > Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP11.phx.gbl
> > Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.aspnet:158558
> > X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
> > Hi,
> > I need to display a DateTime field in 'mm/dd/yyyy' in a DataGrid.. On
> > myGrid1 - Properties - Columns - myColumn1 - Text format string:
> > I tried to put 'mm/dd/yyyy' in there and it displays 'mm/dd/yyyy' in
stead
> > of '04/10/2001'. I know I didn't do it right. Please let me know what's
> the
> > correct way to display a 'mm/dd/yyyy' format for a DateTime coulmn.
> > Thanks.
> > Eddy
Hi Brian,

I finally get it to work now. Earlier I got 00/09/1999 instead of 07/09/1999
because I'm using {0:mm/dd/yyyy}. It's case sensitive, and it must be
{0:MM/dd/yyyy}.

Thanks.

Eddy

"Brian Smith" <smitho@.mantech-wva.com> wrote in message
news:074e01c347cc$f65bfcf0$a001280a@.phx.gbl...
> Eddy,
> I found myself having this problem the other day and
> couldn't find any documentation in the MSDN other than for
> numbers. Here is what you need to put in the format
> string:
> {0:mm/dd/yyyy}
> Also,
> http://asp.net/ is a really good site for anything related
> to ASP .NET or .NET in general. The people in the Forums
> there are very helpful and usually can answer my questions
> within an hour.
>
> >--Original Message--
> >Hi,
> >I need to display a DateTime field in 'mm/dd/yyyy' in a
> DataGrid.. On
> >myGrid1 - Properties - Columns - myColumn1 - Text format
> string:
> >I tried to put 'mm/dd/yyyy' in there and it
> displays 'mm/dd/yyyy' in stead
> >of '04/10/2001'. I know I didn't do it right. Please let
> me know what's the
> >correct way to display a 'mm/dd/yyyy' format for a
> DateTime coulmn.
> >Thanks.
> >Eddy
> >.
"Eddy Soeparmin" <esoeparmin@.clientprofiles.com> wrote in message news:<udPQR07RDHA.2008@.TK2MSFTNGP11.phx.gbl>...
> Hi,
> I need to display a DateTime field in 'mm/dd/yyyy' in a DataGrid.. On
> myGrid1 - Properties - Columns - myColumn1 - Text format string:
> I tried to put 'mm/dd/yyyy' in there and it displays 'mm/dd/yyyy' in stead
> of '04/10/2001'. I know I didn't do it right. Please let me know what's the
> correct way to display a 'mm/dd/yyyy' format for a DateTime coulmn.
> Thanks.
> Eddy

try {0:d} in the datafomatstring property

John