Question

3
Replies
2887
Views
Close popover
Nicola Gazzilli (NicolaG10)
Reply S.P.A.
Consultant
Reply S.P.A.
IT
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 Experience
Moderation Team has archived post,
Close popover 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.