[Solved] Date formatting

[Soren Michelsen]

What are the (if any) requirements for being able to have data formatted as a Date in a defined format?

In my database, a date (september 4, 2009) is stored as 20090904

How do I get this formatted as something sensible in my grid? And as something that I can filter on?

Jeppe Jespersen
Denmark

[Princy]

Hello Jeppe Jesperson,

You can use the DataFormatString for the required column as shown below:
aspx:

 <telerik:GridBoundColumn DataFormatString="{0:MM/dd/yyyy}" DataField="date" UniqueName="column" HeaderText="Date">
 </telerik:GridBoundColumn>

Thanks
Princy.