I have a bound datagrid ( bound to a dataview ). One of the
fields is a datetime field. I wish to format the date display
of this bound datetime column. Instead of showing
dd/mm/yyy hh:mm:ss - I wish to show just dd/mm/yyyy.

Do I use a column style to format the date?
If so how? Can anyone point me to examples
of formatting bound datagrid columns ?

Thanks.

Here is the list of BoundColumn members:
http://msdn.microsoft.com/library/de...mberstopic.asp

One of them is DataFormatString:
http://msdn.microsoft.com/library/de...tringtopic.asp

Here's the overview for formatting:
http://msdn.microsoft.com/library/de...ngOverview.asp

And here are details for date and time string formats:
http://msdn.microsoft.com/library/de...matstrings.asp

Peter
------------------------------------------------------
Work smarter, not harder.

Sorry dont quite understand.
Is the dataformatstring under datagrid.columns.?
I cant find any examples at MS.
How do I set the formatstring on my grid column?

<asp:BoundColumn ... DataFormatString="dd:MM:yyyy"></asp:boundcolumn>

Peter
------------------------------------------------------
Work smarter, not harder.

Thanks Peter
I didn't realise I could edit the HTML directly
and place formatting code in there (still learnin').

Hi-
I needed the same thing and tried the format, but it displays "dd:mm:yyyy" instead of the real value. What I am doing wrong here? Your response will be greatly appreciated.
Thanks
Renu

change the date into a string before you put it into dataview :D

Try DataFormatString="{0:dd-mm-yyyy}"
hope this helps



love never fails

<asp:BoundColumn DataField=startDate HeaderText="startDate" DataFormatString="{0:dd-MMM-yyyy HH:mm:ss}">
</asp:BoundColumn>

Hope this code snippet helps!


Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com

For short date use the following DataFormatString:

{0:d}