Forum Discussion

vaidyarm's avatar
vaidyarm
Contributor
7 years ago

Converting string into date and applying transformation failing

I am passing a timestamp as a variable through pipeline parameter as ‘p_querystring_modifieddateafter’. while applying logic as below in mapper and in REST GET snap parameters, I am getting the fai...
SpiroTaleski's avatar
SpiroTaleski
Valued Contributor
2 years ago
Copy Link

@arvindnsn  

Probably the easiest way is to remove the part "DD/MM/YYYY HH24:MI" from the input string, parse it and converts it to a target date-time format. 

Date.parse("30/01/2024 00:00 'DD/MM/YYYY HH24:MI' ".substr(0,"30/01/2024 00:00 'DD/MM/YYYY HH24:MI' ".indexOf("'")).trim(),"dd/MM/yyyy HH:mm").toLocaleDateTimeString({"format":"yyyy-MM-dd HH:mm:ss.SSS"})
  • ptaylor's avatar
    ptaylor
    Employee
    5 years ago
    Copy Link

    I see. Then an Exit snap at the end of the pipeline, plus my fix to the Head snap, will solve this. The Head fix will be in the November release (4.23).