Date format

[Guest]

How to i bring the date in (dd/mm/yyyy) format from the database?

Here is what am doing... but having problem converting the string into the
short date (dd/mm/yyyy)

string strDateReturned =
((DbDataRecord)e.Item.DataItem)["DateReturned"].ToString();

many thanks

 

[Guest]

make sure the culture is set to a culture that views dates in the format you
wish. For EN-US, the standard is mm/dd/yyyy. To flip, you need to ensure the
culture is in a format that will yield dd/mm/yyyy before displaying the date.
That should solve your problem.

---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************

 

[Guest]

Ok this works:
<%# String.Format("{0:d}",DataBinder.Eval(Container.DataItem,
"DateReceived"))%>

but if i try to do the same in code behind it does not work..

string strDateReturned =
((DbDataRecord)e.Item.DataItem)["DateReturned"].ToString();

String.Format("{0:d}",strDateReturned);

whats wrong?

make sure the culture is set to a culture that views dates in the format you
wish. For EN-US, the standard is mm/dd/yyyy. To flip, you need to ensure the
culture is in a format that will yield dd/mm/yyyy before displaying the date.
That should solve your problem.

---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************

How to i bring the date in (dd/mm/yyyy) format from the database?

Here is what am doing... but having problem converting the string into the
short date (dd/mm/yyyy)

string strDateReturned =
((DbDataRecord)e.Item.DataItem)["DateReturned"].ToString();

many thanks

 

[William F. Robertson, Jr.]

This should work.

string dateReturned = ( ( DateTime )( (
DbDataRecord)e.Item.DataItem)["DateReturned"] ).ToString( "dd/MM/yyyy" );

You will need to cast it from a object to a DateTime, then you can call the
..ToString() method passing the formatter you want to use.

bill

 

[Guest]

Thanks bill, that what i needed

This should work.

string dateReturned = ( ( DateTime )( (
DbDataRecord)e.Item.DataItem)["DateReturned"] ).ToString( "dd/MM/yyyy" );

You will need to cast it from a object to a DateTime, then you can call the
..ToString() method passing the formatter you want to use.

bill

How to i bring the date in (dd/mm/yyyy) format from the database?

Here is what am doing... but having problem converting the string into the
short date (dd/mm/yyyy)

string strDateReturned =
((DbDataRecord)e.Item.DataItem)["DateReturned"].ToString();

many thanks