Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Change date Format - Multiple fields

snavee16
6 - Meteoroid

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 date
Initial Price Wire Recd FBSC
Final Price Wire Recd FBSC
PFM Qualification Completed Date
Price Validation Completed Date
Effective Date
Conceps/ DORA
Invoice Live Date

 

1 REPLY 1
apathetichell
20 - Arcturus

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.

Labels
Top Solution Authors