Parse Date In List Mapping Step

[Deleted User]
[Deleted User]
in Flows

My process takes in a CSV file and creates a simple database data structure using the CSV To List Mapping step as a mediator. I have a date field with a value passed in as DDMMYYYY, but the database data structure requires it to be DD/MM/YYYY. How can I convert this value?

Comments

  • [Deleted User]
    [Deleted User]

    This can be done by using the Default Converter flow Convert String to Date within the Mapping Editor of the CSV To List Mapping step.

    Parse String To Date_1.png

    Choose Show Item Mapping Editor and a pop-up window will open. Here you will map the Field from your CSV file to the appropriate database data structure field on the right-hand side. In my case, it would be HireDate. You will change the Action to Run Converter and choose Convert String to Date.

    Parse String To Date.png

    Building and Using Converter Flows: https://documentation.decisions.com/docs/using-converter-flows

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Register

Categories