Format Date in Databound column

[Vaughn Haybittle]

Hi,

I have a Gridview which is populated via a stored procedure. One of the
coumns returned is a date. The date is currently displayed as 18/01/2007
00:00:00. I just want to show the date without the time i.e. 18/01/2007. I
have tried adding a dataformatstring of {0:d} but it is not making any
difference.

Can anyone advise me on what I am doing wrong?

T.I.A.

Vaughn

 

[Eliyahu Goldin]

Set HtmlEncode = false for the column.

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net

 

[Vaughn Haybittle]

Hi,

Thanks for the information. It worked perfectly. Can you please explain
briefly why changing this property made a difference.

Many thanks,

Vaughn

Set HtmlEncode = false for the column.

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net

Hi,

I have a Gridview which is populated via a stored procedure. One of the
coumns returned is a date. The date is currently displayed as 18/01/2007
00:00:00. I just want to show the date without the time i.e. 18/01/2007.
I have tried adding a dataformatstring of {0:d} but it is not making any
difference.

Can anyone advise me on what I am doing wrong?

T.I.A.

Vaughn

 

[Eliyahu Goldin]

By default the column value is html encoded and, naturally, can be a string
only. Neither number nor date.

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin

Hi,

Thanks for the information. It worked perfectly. Can you please explain
briefly why changing this property made a difference.

Many thanks,

Vaughn

Set HtmlEncode = false for the column.

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net

Hi,

I have a Gridview which is populated via a stored procedure. One of the
coumns returned is a date. The date is currently displayed as 18/01/2007
00:00:00. I just want to show the date without the time i.e. 18/01/2007.
I have tried adding a dataformatstring of {0:d} but it is not making any
difference.

Can anyone advise me on what I am doing wrong?

T.I.A.

Vaughn