Date Time question

[mark]

Hello

I search SQL DB and display results to an APS.Net page using <asp:repeater
/>

One of the columns is a Date in the Database SmallDate .

When I display it the page it shows Date and Time. How can I get rid of Time
and have only date displayed.

All help is greatly appreciated.

Mark

[Elton Wang]

If you are using DataBinder.Eval method, you can pass third parameter,
format string:

DataBinder.Eval(Container.DataItem, "DateTime_field", "{0:MMM dd yyyy}")

HTH


"mark" <mtschndler@yahoo.com> wrote in message
news:%23eUwIJ57FHA.2384@TK2MSFTNGP12.phx.gbl...

> Hello
>
> I search SQL DB and display results to an APS.Net page using <asp:repeater
> />
>
> One of the columns is a Date in the Database SmallDate .
>
> When I display it the page it shows Date and Time. How can I get rid of
> Time and have only date displayed.
>
> All help is greatly appreciated.
>
> Mark
>