[Solved] Datetime column's local timezone conversion issue

[Samnang]

Hi,

I have a requirement of dispalying date without conversion to local timezone at browser. With the current Grid, it does conversion to local timezone which I don't want.

Is there any idea to prevent such conversion happend on client side?

Thanks,
Sam

[Shinu]

Hi Sam,

I guess you want to display DateTimeColumn values in particular date format. If so you could set the DateFormatString property to provide a custom format for the items in the column.

ASPX:

<telerik:GridDateTimeColumn UniqueName="DateTime" HeaderText="Order Date" DataField="OrderDate"
    DataFormatString="{0:dd/MM/yyyy}">
</telerik:GridDateTimeColumn>

-Shinu.

[Samnang]

Thanks again Shinu for your reply.

Actually, I don't have problem with date format. Let me try to explain what is going on.

I am using web service to do filtering/soring/paging invoked by javascirpt client's OnCommnad event. So databinding is happening on client side (browser). What happened is when databinding happens, Grid internally calls Date.localeFormat which convert to local timezone. For example, if date from server is 2008-12-31 11:59 PM PST, Grid will display 2009-01-01 if user is browsing from India.

Thanks,
Sam