Chart Date Time data display in specific timezone not local timezone

[Peter]

i have a chart control that i am populating programmatically using the following options

<XAxis Type="Date" BaseUnit="Auto" >
            <TitleAppearance Text=""> </TitleAppearance>
            <LabelsAppearance DataFormatString="HH:mm"> </LabelsAppearance>
        </XAxis>

 

ScatterSeriesItem ssi1 = new ScatterSeriesItem();
ssi1.X = ConvertToJavaScriptDateTime(Convert.ToDateTime(DR[1].ToString()));
ssi1.Y = Convert.ToDecimal(DR[2].ToString());

 

private decimal ConvertToJavaScriptDateTime(DateTime fromDate)
       {
           return (decimal)fromDate.Subtract(new DateTime(1970, 1, 1)).TotalMilliseconds;
       }

 

and doing this the data in the chart is always displayed in local time especially the x axis, is there any way of formatting the dates so that they dont display in the local time for the browser.

 

[Vessy]

Hi Peter,

You can see a possible approach to keep a Datetime property in U"NC format on both server and client:
http://docs.telerik.com/aspnet-mvc/helpers/grid/how-to/editing/utc-time-on-both-server-and-client

The article targets MVC, but it is a general approach so you can use it in Webforms as well.

Regards,
Vessy
Telerik by Progress