Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Nicola Gazzilli (NicolaG10)
Reply S.P.A.
Consultant
Reply S.P.A.
IT
NicolaG10 Member since 2018 12 posts
Reply S.P.A.
Posted: Aug 19, 2019
Last activity: Sep 4, 2019
Posted: 19 Aug 2019 7:06 EDT
Last activity: 4 Sep 2019 3:36 EDT
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***

To see attachments, please log in.
Data Integration
User Experience

Accepted Solution

Posted: 5 years ago
Posted: 4 Sep 2019 3:36 EDT
Nicola Gazzilli (NicolaG10)
Reply S.P.A.
Consultant
Reply S.P.A.
IT

Hi, 

at the end I've resolved converting the string in this way: @substring(.myDate,0,4)+@substring(.myDate,5,7)+@substring(.myDate,8,10)

Thanks to all

To see attachments, please log in.
Posted: 5 years ago
Posted: 19 Aug 2019 23:02 EDT
Srinivas B Y (SrinivasB9086)
Optum

Optum
IN

Hi, 

Can you try adding the following DSS settings:

DisableEpochDate - true 

DisableEpochDateTime - true 

Both of these are owned by ruleset "Pega-IntegrationEngine"

Make these changes and then try @FormatDateTime function.

Thanks

To see attachments, please log in.
Posted: 5 years ago
Posted: 20 Aug 2019 8:52 EDT
Arun Kumar (Arun_Kumar)
Tekclan
Lead System Architect
Tekclan
IN
Hi Nicola Gazzilli, As per my Understanding, the String format you provided is not a valid format ("2019-01-19T03:00:00.000Z") for function @FormatDateTime to understand as @FormatDateTime and @toDateTime function can only accept a String in the following format for example: "20190119T030000.000 GMT" and will convert it to a DateTime property. But in your Scenario, as it is unable to get the proper format it is providing you a default value 19700101. Thanks.
To see attachments, please log in.

Accepted Solution

Posted: 5 years ago
Posted: 4 Sep 2019 3:36 EDT
Nicola Gazzilli (NicolaG10)
Reply S.P.A.
Consultant
Reply S.P.A.
IT

Hi, 

at the end I've resolved converting the string in this way: @substring(.myDate,0,4)+@substring(.myDate,5,7)+@substring(.myDate,8,10)

Thanks to all

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice