Question

5
Replies
3758
Views
AparnaGopakumar Member since 2015 29 posts
TCS
Posted: 2 years ago
Last activity: 2 years 10 months ago
Closed

Converting UTC to GMT timing

I'm looking for a function which can convert UTC time to GMT.

Tried using @DateTime.FormatDateTime function, but it results null value when DateTime string is my input value in UTC. Strangely it works for @CurrentDatetime()

More details here

*Updated to add more info*

I'm using Version 7.2.

And am trying to convert a parameter with value 2017-04-07T05:00:00.000Z to the format 20170407T050000.000 GMT

The main purpose of this conversion is to make use of @DateTime.CompareDates() functions which right now is resulting in Invalid date format error with UTC format. ( it works correctly with GMT format)

Thanks

***Updated by moderator: Lochan to add Categories***

Data Integration User Interface
Moderation Team has archived post
Share this page LinkedIn