Removing the time

[MasterChief]

I have a gridview that is bound to a date/time field in sql. How can I
remove the time part of it so it doesn't show up at all in the gridview?

 

[john smith]

I have a gridview that is bound to a date/time field in sql. How can I
remove the time part of it so it doesn't show up at all in the gridview?

Use the DataFormatString property of the bound field to format the date
accordingly i.e. DataFormatString="{0:yyyy-MM-dd}" or whatever other
format you like/want.

 

[Guest]

I have a gridview that is bound to a date/time field in sql. How can I
remove the time part of it so it doesn't show up at all in the gridview?

You can format the data in SQL... or use the OnItemDatabound Event to
format the time... or you can use a databinding expression to format it as
well.

So there are multiple ways to do it : )

 

[MasterChief]

Works like a charm thank you.

 

[Sonu Kapoor]

http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=181

Sonu Kapoor [MVP]