Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

Equivalent to CONVERTDATETIME function from Scribe Insight to Scribe Online.


Gourav Kalra

Recommended Posts

I see a function CONVERTDATETIME( DateTime, "FromUTCOffset", "US" | "EU" | "AU" | " ", "ToUTCOffset", "US" | "EU" | "AU" | "" )

for the scribe insight. Do we have an equivalent to convert the UTC to local time for the Scribe Online.

Thanks.

Link to comment
Share on other sites

  • 3 weeks later...

Hi,

I would say you could try using the DATEADD formula. Based on the UTC time difference to your local time. for example, when you are in UTC + 2

(DATEADD("h", 2, MyEntity.Date)) to add 2 hours to the supplied date.

You can also do Minus

(DATEADD("h", -2, MyEntity.Date)) to subsctract 2 hours

thanks

NIck

Link to comment
Share on other sites

×
×
  • Create New...