Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Invoice Date formatting

SH_94
10 - Fireball

Hi Community,

 

Would like to ask how to convert the following the date format to the output as per below.

Original

1.09/29/2015

 

Output

1.2015-09-29

 

Do we need to choose the type as date if we need the output as above?

 

many thanks again for the help

3 REPLIES 3
MarqueeCrew
19 - Altair
19 - Altair

Formula:

 

 datetimeparse([original],"%m/%d%Y")

 

 this will create a good date for Output. 

cheers,

 

 mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Please Subscribe to my youTube channel.
atcodedog05
21 - Polaris

Hi @SH_94 

 

Here is one way of doing it using datetime tool, select string to date and give the input date format.

 

Workflow:

atcodedog05_0-1642093461856.png

 

Hope this helps : )

 

Qiu
18 - Pollux

@SH_94 
I am not sure if the prefix "1." is important, gave a try.

0114-SH_94.PNG

Labels