Hi @Mihai Melencu , thanks for replying.

Yeah, I'm using the ArrangeData action in DataAction.

Here's the logic loading data into the DataGrid.
It just gets sample data via Aggregate and convert it to JSON.

I read that starting from a certain version of the OutSystems DataGrid, the ArrangeData function automatically converts DateTime values to UTC. The version I'm using doesn’t do that, so it’s difficult for me to test. 

However, here’s a code snippet that should force the DataGrid to display times in the local timezone instead of UTC. You’ll need to implement this code in the OnInitialize event of the DataGrid and make sure to update the column’s binding accordingly: 

• var fg = OutSystems.GridAPI.GridManager.GetGridById($parameters.GridWidgetId).provider;
• 
  
• var dateFormat = 'yyyy-MM-dd HH:mm';
• 
  
• fg.formatItem.addHandler(function (s, e) {
•   if (s.editRange) return;
• 
  
•   if (e.panel === s.cells) {
•     var col = s.columns[e.col];
•     if (col && col.binding === 'Data.Date') {
•       var raw = e.panel.getCellData(e.row, e.col, false);
•       if (raw != null && raw !== '') {
•         var localDate = new Date(raw);
•         e.cell.textContent = wijmo.Globalize.format(localDate, dateFormat);
•       }
•     }
•   }
• });

Thanks! 

You were right. It was ArrangeData action's behaviour.

If I use JSONSerialize action instead, the date will be converted nicely.

I found a forum post mentioning this behaviour.

https://www.outsystems.com/forums/discussion/76997/outsystems-data-grid-arrangedata-no-longer-convert-date-time-to-local-timezone/

According to this, the behaviour in question is a side-effect from addressing another issue.

And the code snippet you gave me worked as well, but I had to manually offset the time zone in it to make it work.
It seems "new Date();" will just re-label the UTC date to JST date without offsetting time.

In summary, I have two options to solve my problem:

1. Use the code snippet in DataGridOnInitialize to offset datetime values in grid.

2. Use JSONSerialize in server action instead of ArrangeData.
(Maybe this is not recommended)

Anyways, thanks for your help!
Cheers!

Hi @Jamal Mohammed , thanks for replying.

Yeah, currently I'm doing almost the same approach (manually offsetting time zone on server side).
However passing time zone offset to every DataGrid-related server calls feels less practical for me, because we don't have to do that if it wasn't for DataGrid...right?

Aren't there any way to make DataGrid automatically offset timezone?

Please note that, when you do this on Server side it would give you server timezone. Use Javascript Instead.