Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Date Format Error

Jeyaraj_M
7 - Meteor

Hi,

 

I am trying to convert the date format but it shows an error as invalid date format

 

CustomerValid from
1234561-Nov-18
22589761-Oct-18

 

My expected output is

 

CustomerValid from
12345611.2018
225897610.2018
4 REPLIES 4
purnimat
7 - Meteor

Hi @Jeyaraj_M ,

 

Using the Date Time parse tool and the Formula tool, you can achieve the desired output.

 

purnimat_0-1595325342977.png

 

Hope this helps !

DavidP
17 - Castor
17 - Castor

You can also do it all in one with a formula

 

DavidP_0-1595326388878.png

 

 

Jeyaraj_M
7 - Meteor

Can you please share me that Workflow?

 

i tried it but it is not converting to the expected output please

purnimat
7 - Meteor

Here you go @Jeyaraj_M 

Labels