We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

render a DateTime column in local time, not in UTC

Hi, I want to display a column with DateTime objects in it. But if I try to set the format string either to col.StyleInfo.Format = CultureInfo.CurrentCulture.DateTimeFormat.FullDateTimePattern ; or to col.StyleInfo.Format = "dd.MM.yy - HH:mm:ss"; all the times are displayed as UTC. How can I tell the StyleInfo to use the local timezone? Otherwise it would be a great deal to convert all the table entries manual. Thanks in advance, Alex.

1 Reply

AD Administrator Syncfusion Team June 22, 2005 05:27 PM UTC

So, the dates are displayed in the proper format, it is just that the time is the wrong value. If this is a readonly grid, then you could use the grid.DrawCelDisplayText event. There you can get the DateTime object from the style.CellValue. Then call the ToLocalTime() method on this DateTime object to convert it from UTC to local. Then you can format the converted object, and set the formatted string into e.Text. If it is not a ReadOnly grud, then you would have to use the QueryCellFormattedText and SaveCellFormattedText events to flip the time from UTC to local in QueryCellFromattedText and then from local to UTC in SaveCellFormattedText. DateTime d; d.ToLocalTime();

Live Chat Icon For mobile
Up arrow icon