Forum Discussion

Sahil's avatar
Sahil
Contributor
5 years ago
Solved

Need to convert yyyymmdd to yyyy-mm-dd

Hi, I have a element as:- jsonPath($, “$Z_ORD.IDOC.DK02[].DATE") and value is coming as 20210521(yyyymmdd). I need to convert it to 2021-05-21 and map it to target ml element. I am using ma...
date
expression_language
pattern
  • bojanvelevski's avatar
    bojanvelevski
    5 years ago

    I ment at the end of my expression which parsed your date.

    Date.parse($Z_ORD.IDOC.DK02.map(x=>x.DATE.toString().substring(0,4)).concat($Z_ORD.IDOC.DK02.map(x=>x.DATE.toString().substring(4,6)),$Z_ORD.IDOC.DK02.map(x=>x.DATE.toString().substring(6))).join(“-”)).toLocaleDateString()

Sahil's avatar
Sahil
Contributor
5 years ago

Hi,
Thank you for the reply.
1st option was throwing error so I tried 2nd one but getting date as
2021-03-17T00:00:00.000 UTC

it should be just, please let me know how do I rectify it.
2021-03-17