How do I get date columns to recognize the culture of the radgrid?

[Javier]

I have a radgrid and the dates should be formatted to display in the proper culture.

I set the culture in the radgrid as follows

<telerik:RadGrid runat="server" ID="rgdGroupOrder" CellSpacing="0" GridLines="None" Culture="en-AU">

The date columns are databound to datetime objects.

<telerik:GridBoundColumn DataField="ScheduleDateTime" DataType="System.DateTime" FilterControlAltText="Filter ScheduleDateTime column"
    HeaderText="Schedule Date/Time" SortExpression="ScheduleDateTime" UniqueName="ScheduleDateTime" >
</telerik:GridBoundColumn>

No matter what I do the datetime formats always appear in the US format (mm/dd/yyyy) when they should be (dd/mm/yyyy).

I would like to apply a standard date format to these columns as well to clean up the way they look.  So the markup will look like this.

<telerik:GridBoundColumn DataField="ScheduleDateTime" DataType="System.DateTime" FilterControlAltText="Filter ScheduleDateTime column"
    HeaderText="Schedule Date/Time" SortExpression="ScheduleDateTime" UniqueName="ScheduleDateTime" DataFormatString="{0:g}">
</telerik:GridBoundColumn>

The only difference is that the DataFormat property is set.

Thanks

[Shinu]

Hi,

Try setting the DataFormatString as shown below.

ASPX:

<telerik:GridBoundColumn DataField="ScheduleDateTime" DataType="System.DateTime" FilterControlAltText="Filter ScheduleDateTime column"
    HeaderText="Schedule Date/Time" SortExpression="ScheduleDateTime" UniqueName="ScheduleDateTime" DataFormatString="{0:dd/MM/yyyy}">
</telerik:GridBoundColumn>

Thanks,
Shinu.

[Javier]

Thank for the help, but that won't solve my problem. The culture will be set dynamically per user which is why I'm using it.  
I just hard coded it for the example for the sake of simplicity.

We have clients in different parts of the world, and their culture is set for their own installation of the software.

Is this a bug, what is the culture setting of the grid supposed to do?  Should I open a ticket?

Thanks

[Radoslav]

Hello Javier,

To achieve the desired functionality you need to set the Culture to the page where the RadGrid is placed. For example:

<%@ Page Title="Home Page" Language="C#" MasterPageFile="~/Site.master" Culture="en-AU" AutoEventWireup="true"
    CodeFile="Default.aspx.cs" Inherits="_Default" %>

I am sending you a simple example which demonstrates that. Please check it out end let me know if it helps you.

Regards,
Radoslav
the Telerik team

[Javier]

That worked perfectly, thanks.

[Alex]

Then what is the purpose of setting the grid culture if it does nothing