It is because the
parse method expects a number but you are providing a string value.
You need to parse the “Modified_Date”, you can do so by using
In your case would be:
And the full expression to format the date would be:
You can change your desired formatting in this section : “format”:“yyyy-MM-dd HH:mm:ss”
Place this expression into mapper snap and dynamically your_input_date will be picked up and formatted accordingly.