show just the date in a datagrid column when the datafield is an datetime field

[Adil Bohoudi]

Hi all,

i'm using a datagrid to show somedata retrieved from an sql-server 2000.

this datagrid contains two columns a startdate and an enddate column.
i used a storedprocedure to get both dates. but when i use the following
code:

datagrid.datasource = selDates()
datagrid.bind()

both columns show the retrived datetime value. it's a little bit ugly to
see.......... the only thing i need is just the date value....

does someone know how to show only the datepart in a datagrid column

thanks in advance,

Adil

[Eric Wise]

Set your formatting expression to be {0:d}
"Adil Bohoudi" <adil_dev@hotmail.com> wrote in message
news:R86Ya.34454$FN3.2595642@news.ono.com...

> Hi all,
>
> i'm using a datagrid to show somedata retrieved from an sql-server 2000.
>
> this datagrid contains two columns a startdate and an enddate column.
> i used a storedprocedure to get both dates. but when i use the following
> code:
>
> datagrid.datasource = selDates()
> datagrid.bind()
>
> both columns show the retrived datetime value. it's a little bit ugly to
> see.......... the only thing i need is just the date value....
>
> does someone know how to show only the datepart in a datagrid column
>
> thanks in advance,
>
> Adil
>
>