Formatting all dates

[Rickard]

Hello. I have a grid that shows some data from a database, just the essentials, and there i've formatted my dates by binding each column manually and applying a format to it.

However, i also have a detailed view, in which the grid is filled with obscene amounts of data, and binding each and every column just so i can get the dates to show in a proper format isn't very practical.

Is there any way to format all dates output by the MVC Grid in a particular fashion? Say yyyy-MM-dd?

Thanks.

[Atanas Korchev]

Hi Rickard,

 The only built-in way to customize the format of date columns is via the Format setting:

columns.Bound(o => o.OrderDate).Format("{0:dd/MM/yyyy}");

You said that you are binding each column manually - could you please explain what this means? How are you applying the formatting in this case?

Regards,
Atanas Korchev
the Telerik team

[Rickard]

By binding them manually, i mean i am writing out the columns instead of letting the grid autogenerate them. And in that case, i am formatting the date just like your example.

My question is, perhaps more clearly, is there a way to make autogenerated datetime columns come out in a specified format?

Thanks.

[Atanas Korchev]

Hi Rickard,

Yes this is possible:

<%= Html.Telerik().Grid(Model)
        .Name("Grid")
        .Columns(columns =>
                {   
                    columns.AutoGenerate(column =>
                        {                            
                            if (column.Member == "CustomerID")
                                column.Format = "{0:dd/MM/yyyy}";
                        });                        
                })
 %>

Kind regards,
Atanas Korchev
the Telerik team