Start Free Trial

Alteryx Designer Desktop Discussions

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

Date Format file merge

EmilAlteryx01
8 - Asteroid

The Date column on one input file for the workflow is in a mm/dd/yyyy while on the other yyyy-mm-dd

So now my Date column reads as ,

 

Date

08/23/2022

08/02/2022

2022-08-23

 

How do i get all the rows to read in 2022-08-23 format 

4 REPLIES 4
MilindG
12 - Quasar

I'm sure there is a way better way to do this but I converted from string to date and combined the data.

DataNath
17 - Castor
17 - Castor

If these are the only two formats in the field then you could just use a Formula tool with the following expression:

 

if !isnull(DateTimeParse([Date],'%m/%d/%Y')) then DateTimeParse([Date],'%m/%d/%Y') else [Date] endif

 

DataNath_0-1661282445439.png

binuacs
21 - Polaris

@EmilAlteryx01 Another way of doing this by using the Contains function

binuacs_0-1661294602299.png

 

EmilAlteryx01
8 - Asteroid

Thank you All - This worked

Labels
Top Solution Authors