datagrid and datetime field

[Chris]

Is there a way to truncate the Sql Server datetime field when displaying in a
datagrid? I get the date and time, I only want date displayed.
It's a bound column:
<asp:BoundColumn HeaderStyle-CssClass="gridtext" HeaderStyle-Wrap=False
ItemStyle-CssClass="gridtext" ItemStyle-Width="20px" ItemStyle-Wrap=False
DataField="Concern_DMfgDate" HeaderText="Mfg. Date"
SortExpression="Concern_DMfgDate" />
I'm using a view in Sql Server to get the data, maybe I can do it in there?
why does it show only the date (i.e. 1/12/2001) in Sql Server but in grid
date and time show?
1/12/2001 12:00:00 AM

Thanx.

[IPGrunt]

"=?Utf-8?B?Q2hyaXM=?=" <Ch***@discussions.microsoft.com> confessed in
news:5E**********************************@microsof t.com:

Is there a way to truncate the Sql Server datetime field when displaying in a datagrid? I get the date and time, I only want date displayed.
It's a bound column:
<asp:BoundColumn HeaderStyle-CssClass="gridtext" HeaderStyle-Wrap=False
ItemStyle-CssClass="gridtext" ItemStyle-Width="20px" ItemStyle-Wrap=False
DataField="Concern_DMfgDate" HeaderText="Mfg. Date"
SortExpression="Concern_DMfgDate" />
I'm using a view in Sql Server to get the data, maybe I can do it in there? why does it show only the date (i.e. 1/12/2001) in Sql Server but in grid
date and time show?
1/12/2001 12:00:00 AM

Thanx.

Have you tried something like:

DataFormatString="{0:d}"

as a property to your Bound column?

-- ipgrunt

[Chris]

that worked great! Any suggestions on converting True/False to a display of
Yes/No?

"IPGrunt" wrote:

"=?Utf-8?B?Q2hyaXM=?=" <Ch***@discussions.microsoft.com> confessed in
news:5E**********************************@microsof t.com:

Is there a way to truncate the Sql Server datetime field when displaying

in a

datagrid? I get the date and time, I only want date displayed.
It's a bound column:
<asp:BoundColumn HeaderStyle-CssClass="gridtext" HeaderStyle-Wrap=False
ItemStyle-CssClass="gridtext" ItemStyle-Width="20px" ItemStyle-Wrap=False
DataField="Concern_DMfgDate" HeaderText="Mfg. Date"
SortExpression="Concern_DMfgDate" />
I'm using a view in Sql Server to get the data, maybe I can do it in

there?

why does it show only the date (i.e. 1/12/2001) in Sql Server but in grid
date and time show?
1/12/2001 12:00:00 AM

Thanx.

Have you tried something like:

DataFormatString="{0:d}"

as a property to your Bound column?

-- ipgrunt