Format Date from DB

[Wayne Wengert]

I have an aspx page in which I retrieve data from an SQL Server. At one
point I am retrieving a smalldatetime field and I want to display only
"mm/dd/yy" but the default seems to be to add the time. The code to retrieve
that date field is: <%#Container.Da taItem("LastUpd ated")%>

I tried adding ".ToString("d") " but it doesn't recognize that as a
formatting function.

How can I format that returned value as mm/dd/yyyy?

Wayne

[Elton W]

Hi Wayne,

You can use following code to format Date:

<%# DataBinder.Eval (Container.Data Item, "LastUpdate d", "{0: MM/dd/yyyy}") %>

HTH

Elton Wang
El********@hotm ail.com

"Wayne Wengert" wrote:

I have an aspx page in which I retrieve data from an SQL Server. At one
point I am retrieving a smalldatetime field and I want to display only
"mm/dd/yy" but the default seems to be to add the time. The code to retrieve
that date field is: <%#Container.Da taItem("LastUpd ated")%>

I tried adding ".ToString("d") " but it doesn't recognize that as a
formatting function.

How can I format that returned value as mm/dd/yyyy?

Wayne

[Wayne Wengert]

Elton;

Thank you very much. Works perfectly. Where is that documented?

Wayne

"Elton W" <El****@discuss ions.microsoft. com> wrote in message
news:D1******** *************** ***********@mic rosoft.com...

Hi Wayne,

You can use following code to format Date:

<%# DataBinder.Eval (Container.Data Item, "LastUpdate d", "{0: MM/dd/yyyy}")
%>

HTH

Elton Wang
El********@hotm ail.com

"Wayne Wengert" wrote:

I have an aspx page in which I retrieve data from an SQL Server. At one
point I am retrieving a smalldatetime field and I want to display only
"mm/dd/yy" but the default seems to be to add the time. The code to
retrieve
that date field is: <%#Container.Da taItem("LastUpd ated")%>

I tried adding ".ToString("d") " but it doesn't recognize that as a
formatting function.

How can I format that returned value as mm/dd/yyyy?

Wayne

[Elton W]

http://msdn.microsoft.com/library/de...evaltopic2.asp
"Wayne Wengert" wrote:

Elton;

Thank you very much. Works perfectly. Where is that documented?

Wayne

"Elton W" <El****@discuss ions.microsoft. com> wrote in message
news:D1******** *************** ***********@mic rosoft.com...

Hi Wayne,

You can use following code to format Date:

<%# DataBinder.Eval (Container.Data Item, "LastUpdate d", "{0: MM/dd/yyyy}")
%>

HTH

Elton Wang
El********@hotm ail.com

"Wayne Wengert" wrote:

I have an aspx page in which I retrieve data from an SQL Server. At one
point I am retrieving a smalldatetime field and I want to display only
"mm/dd/yy" but the default seems to be to add the time. The code to
retrieve
that date field is: <%#Container.Da taItem("LastUpd ated")%>

I tried adding ".ToString("d") " but it doesn't recognize that as a
formatting function.

How can I format that returned value as mm/dd/yyyy?

Wayne

[Wayne Wengert]

Thanks...

Wayne

"Elton W" <El****@discuss ions.microsoft. com> wrote in message
news:86******** *************** ***********@mic rosoft.com...

http://msdn.microsoft.com/library/de...evaltopic2.asp
"Wayne Wengert" wrote:

Elton;

Thank you very much. Works perfectly. Where is that documented?

Wayne

"Elton W" <El****@discuss ions.microsoft. com> wrote in message
news:D1******** *************** ***********@mic rosoft.com...

> Hi Wayne,
>
> You can use following code to format Date:
>
> <%# DataBinder.Eval (Container.Data Item, "LastUpdate d", "{0:
> MM/dd/yyyy}")
> %>
>
> HTH
>
> Elton Wang
> El********@hotm ail.com
>
>
>
> "Wayne Wengert" wrote:
>
>> I have an aspx page in which I retrieve data from an SQL Server. At
>> one
>> point I am retrieving a smalldatetime field and I want to display only
>> "mm/dd/yy" but the default seems to be to add the time. The code to
>> retrieve
>> that date field is: <%#Container.Da taItem("LastUpd ated")%>
>>
>> I tried adding ".ToString("d") " but it doesn't recognize that as a
>> formatting function.
>>
>> How can I format that returned value as mm/dd/yyyy?
>>
>> Wayne
>>
>>
>>