ASP/DataGrid/BoundColumn/Data formatting expression fo Date?

[Volodymyr Lozovoy]

Hi All,

who suggest why subj do not affect on displayed result for date?

 

[Eliyahu Goldin]

Because you are likely making mistakes.

Eliyahu

 

[Volodymyr Lozovoy]

I think so
but where?

Data format expression is {0:d}- short date format "05/06/04" (it is wrote
in help "Properties for Bound Columns"), but date is rendered as May 6 2004.

 

[Eliyahu Goldin]

If you look in the help for BoundColumn.DataFormatString, you will find that
D (or d) displays numeric values in decimal format. It shouldn't affect date
fields, which is what you are observing.

You can format dates in code-behind in either ItemDataBound or PreRender
event. Get the cell text, convert it to DateTime and format it back to
string with format expression of your choice.

Eliyahu

 

[Volodymyr Lozovoy]

I am newbie in .NET. May be i am wrong.
I agree with you about numeric value, but i have date value.
In the help for Standard DateTime Format Strings "d" is short date pattern.

 

[Volodymyr Lozovoy]

.... even if I use format {0:dd-MM-yy} nothing changes.

 

[Volodymyr Lozovoy]

Do i understand right that all data is in text format?

 

[Volodymyr Lozovoy]

Thank you! I found my mistake.

If you look in the help for BoundColumn.DataFormatString, you will find
that
D (or d) displays numeric values in decimal format. It shouldn't affect
date
fields, which is what you are observing.

You can format dates in code-behind in either ItemDataBound or PreRender
event. Get the cell text, convert it to DateTime and format it back to
string with format expression of your choice.

Eliyahu