Question

5
Replies
4164
Views
Aparna Gopakumar (AparnaGopakumar)
TCS

TCS
IN
AparnaGopakumar Member since 2015 36 posts
TCS
Posted: November 20, 2017
Last activity: November 21, 2017
Posted: 20 Nov 2017 3:13 EST
Last activity: 21 Nov 2017 4:35 EST
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 Experience
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.