nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to display my date in GMT?

BIRT F-Type Fan

How to change my local time to display GMT time? I have a datetime variable and function is - dataSetRow["ActivityDate"] . I want to display both columns with my local time and another with GMT time.

Find more posts tagged with

Comments

micajblock

It is not a simple format as the date needs to be converted to UTC (GMT) and that depends on your time zone. Attached is a sample design that uses a scripted data source so you should be able to run it. 
 
The expression for the UTC date is:
<pre class="_prettyXprint">
new Date(row["ActivityDate"].getUTCFullYear(), row["ActivityDate"].getUTCMonth(), row["ActivityDate"].getUTCDate(), row["ActivityDate"].getUTCHours(), row["ActivityDate"].getUTCMinutes(), row["ActivityDate"].getUTCSeconds());</pre>

bgbaird

This bit of magic will convert localDT to a UTC String. You can then convert it to a DT. 
var localDT = new Date(); 
var utcString = localDT.toUTCString();
 
Brian

padytom

How do I convert integer to a Time format after using this computation
 
BirtDateTime.diffHour (BirtDateTime.now(),row["TARGSTARTDATE"])

micajblock

Please start a new topic as this is not related to the title of this post.
 
P.S. Please provide details on what the inter is (how it applies to time)?