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.DataItem("LastUpdated")%>

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.DataItem, "LastUpdated", "{0: MM/dd/yyyy}") %>

HTH

Elton Wang
El********@hotmail.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.DataItem("LastUpdated")%>

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****@discussions.microsoft.com> wrote in message
news:D1**********************************@microsof t.com...

Hi Wayne,

You can use following code to format Date:

<%# DataBinder.Eval(Container.DataItem, "LastUpdated", "{0: MM/dd/yyyy}")
%>

HTH

Elton Wang
El********@hotmail.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.DataItem("LastUpdated")%>

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****@discussions.microsoft.com> wrote in message
news:D1**********************************@microsof t.com...

Hi Wayne,

You can use following code to format Date:

<%# DataBinder.Eval(Container.DataItem, "LastUpdated", "{0: MM/dd/yyyy}")
%>

HTH

Elton Wang
El********@hotmail.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.DataItem("LastUpdated")%>

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****@discussions.microsoft.com> wrote in message
news:86**********************************@microsof t.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****@discussions.microsoft.com> wrote in message
news:D1**********************************@microsof t.com...

> Hi Wayne,
>
> You can use following code to format Date:
>
> <%# DataBinder.Eval(Container.DataItem, "LastUpdated", "{0:
> MM/dd/yyyy}")
> %>
>
> HTH
>
> Elton Wang
> El********@hotmail.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.DataItem("LastUpdated")%>
>>
>> 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
>>
>>
>>