cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

How to display dateTime as UTC in the mashup grid

Highlighted
Level 1

How to display dateTime as UTC in the mashup grid

Hi,

We are working with dateTime without referring to time zones - it's called floating time (I think).

Anyway, we are getting the date and time without time zone, we are saving it as UTC in the DB.

In the mashup I want to display the date as UTC.

Untill now, what I managed to display is:  2017-03-22 06:22:52+0800 while the input string was: 2017/03/22 10:22:52 I used the format: "yyyy-MM-dd hh:mm:ssZ"

The data is correct besides the need of the user to manually calculate it.

If I'm using expression: new Date(d.setTime(d.getTime() + (d.getTimezoneOffset() * 60 * 1000)))

It will display it nicely as DateTime, but the data is coming and bound to the GRID in the mashup so I'm not sure how to use expression with it.

Is there anything I'm missing here?