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

 

[Guest]

Hi Wayne,

You can use following code to format Date:

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

HTH

Elton Wang
(e-mail address removed)

 

[Wayne Wengert]

Elton;

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

Wayne

 

[Guest]

http://msdn.microsoft.com/library/d...frlrfsystemwebuidatabinderclassevaltopic2.asp

 

[Wayne Wengert]

Thanks...

Wayne

http://msdn.microsoft.com/library/d...frlrfsystemwebuidatabinderclassevaltopic2.asp