Question

3
Replies
1696
Views
NicolaG10 Member since 2018 9 posts
Reply S.P.A.
Posted: August 19, 2019
Last activity: September 4, 2019
Closed
Solved

How to convert a "YYYY-MM-ddThh:mm:ss.sssZ" format string to Date?

Hi all,

in a data transform I've this string "2019-01-19T03:00:00.000Z" and I want to set it in a date property.

If I set it with no convertion I've got error.

If I use @FormatDateTime("2019-01-19T03:00:00.000Z", "YYYY-MM-ddThh:mm:ss.sssZ", null, null) the result is 19700101.

My expected result is 20190101, how can I obtain this?

Thanks in advance.

***Edited by Moderator: Lochan to update platform capability tags***

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