How to display dateTime as UTC in the mashup grid

aelgov — Tue, 21 Mar 2017 08:57:25 GMT

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?

topic How to display dateTime as UTC in the mashup grid in ThingWorx Developers

How to display dateTime as UTC in the mashup grid