Hello,
I am working on several grids that contain a date column. In the database the date/time is in UTC. I have a method that converts the UTC date to any time zone specified. I have a control that allows the user to select a time zone. I would like to show the date in the specified time zone. If the user changes the time zone the date column updates.
My prototype creates a DataTable in code behind and calculates the data as it populates the rows.
Do you think this is the best way? It seems like there should be a way to hook into the onDisplay event for that field and modify it as it is being displayed. That would be cleaner and allow use of the field property editors.
Thanks
Barry
I am working on several grids that contain a date column. In the database the date/time is in UTC. I have a method that converts the UTC date to any time zone specified. I have a control that allows the user to select a time zone. I would like to show the date in the specified time zone. If the user changes the time zone the date column updates.
My prototype creates a DataTable in code behind and calculates the data as it populates the rows.
Do you think this is the best way? It seems like there should be a way to hook into the onDisplay event for that field and modify it as it is being displayed. That would be cleaner and allow use of the field property editors.
Thanks
Barry