Change date Format - Multiple fields

Question

Hi ,

could someone help me with changing date format for multiple fields from YYYY-MM-DD To MM-DD-YYYY for multiple fields.

The multiple fields are below and i have attached my workflow and input file.

Agreed Go-live dateInitial Price Wire Recd FBSCFinal Price Wire Recd FBSCPFM Qualification Completed DatePrice Validation Completed DateEffective Date
Conceps/ DORAInvoice Live Date

Date format.yxmd

Dummy.xlsx

apathetichell · Accepted Answer

Here's a multi-field which will take a date field and change it to string field in the mm-dd-yyyy format... notes:

i wasn't sure which fields you wanted based upon your descriptions - so just click them in the multi-field tool and they'll be created. I left the originals as dates since mm-dd-yyyy is a string and can't be used for date/time calculations.