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