[Solved] MVC Grid DatetimePicker format

[chris]

When I deployed this to the server I get the error of "The value '18/05/1974' is not valid for D.O.B.." when doing in grid editing

My View:

<%= Html.Telerik().Grid<SDAC.Models.Runner>()
        .Name("Grid")
        .DataKeys(keys =>
        {
            keys.Add(p => p.id);
        })
        .ToolBar(commands => commands.Insert().ButtonType(type).ImageHtmlAttributes(new
            {style="margin-left:0"}))
        .DataBinding(dataBinding =>
        {
            dataBinding.Ajax()
                .Select("_Select", "Runner")
                .Insert("_Insert", "Runner")
                .Update("_Save", "Runner")
                .Delete("_Delete", "Runner");
        })
        .Columns(columns =>
        {
            columns.Bound(o => o.lastname);
            columns.Bound(o => o.firstname);
            columns.Bound(o => o.sex).Width(40);
            columns.Bound(o => o.Active).Width(40);
            columns.Bound(o => o.dob).Format("{0:dd/MM/yyyy}").Width(100);

            columns.Command(commands =>
            {
                commands.Edit().ButtonType(type);
                commands.Delete().ButtonType(type);
            }).Width(180).Title("Commands");
        })
            .Editable(editing => editing.Mode(mode))
            .Scrollable(scrolling => scrolling.Enabled(false))
            .Sortable(sorting => sorting.Enabled(true))
            .Pageable(paging => paging.PageSize(10))
            .Filterable(filtering => filtering.Enabled(true))
            .Groupable(grouping => grouping.Enabled(true))
            .Footer(true)
%>

Editor Template Date.ascx

<%= Html.Telerik().DatePicker()
        .Name(ViewData.TemplateInfo.GetFullHtmlFieldName(string.Empty))
        .HtmlAttributes(new { id = ViewData.TemplateInfo.GetFullHtmlFieldId(string.Empty) + DateTime.Now.Millisecond.ToString() })
        .Value(Model > DateTime.MinValue? Model : DateTime.Today)
        .Format("dd/MM/yyyy")
%>

See attached screenshot.
If I input the date in my desired format (dd/MM/yyyy) I get the format validation error.
If I input the date in US format (MM/dd/yyyy) the value is saved and then displayed in the correct dd/MM/yyyy format.
What do I need todo so that I do not get this validation error?

[Atanas Korchev]

Hello chris,

 You need to set the current culture to en-UK and enable globalization for the script registrar:

<%= Html.Telerik().ScriptRegistrar().Globalization(true) %>

Regards,
Atanas Korchev
the Telerik team

[chris]

Thanks for your help.
Where / how should I set the culture?

[Atanas Korchev]

Hi chris,

 You can check the How to: Set the Culture and UI Culture for ASP.NET Web Page Globalization MSDN help article.

Greetings,
Atanas Korchev
the Telerik team

[chris]

Thank you. This worked perfectly.

I added the following line under system.web in my web.config

<globalization uiCulture="en" culture="en-GB" />

and changed my script registrar

<%= Html.Telerik().ScriptRegistrar().Globalization(true) %>