Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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
18 - Pollux

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