Date Format conversion

[G-Balamurugan]

Whether we can , change the date format

Input : { "date" : "2024-03-01" }

Output : { "date" : "01/03/2024" }

[bobeal]

Not something Jolt really shines in but you can achieve it with the following transformation:

[
  {
    "operation": "modify-overwrite-beta",
    "spec": {
      "year": "=substring(@(1,date), 0, 4)",
      "month": "=substring(@(1,date), 5, 7)",
      "day": "=substring(@(1,date), 8, 10)",
      "date": "=concat(@(1,day),'/',@(1,month),'/',@(1,year))"
    }
  },
  {
    "operation": "remove",
    "spec": {
      "year": "",
      "month": "",
      "day": ""
    }
  }
]

[G-Balamurugan]

Thanks @bobeal , for your quick response