Alteryx Designer Discussions

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

CONVERTING FROM STRING FORMAT TO DATE FORMAT

dunkindonut7777
8 - Asteroid

Hi I would like to ask if how can I convert the unusual date that has a string type of data to date format.

 

Date (String)Expected output (Date)
05-MAR-20182018-03-05
22-JUN-20182018-06-22

 

How can I convert it according to the date format? Thanks

 

4 REPLIES 4
AngelosPachis
15 - Aurora

Hi @dunkindonut7777 ,

 

You can use a date time tool to do that, configured to convert a string to a date format.

 

AngelosPachis_0-1631701473758.png

 

The format should be set to custom and the expression is dd-Month-yyyy as shown above.

 

Hope that helps,

Angelos

Ar13f
8 - Asteroid

Dear @dunkindonut7777 

 

another way can use with "formula tool"

 

Change Date.png

 

please see the attachment of my workflow ... hope this helps what you want..

StephaneP
Alteryx
Alteryx

Hello @dunkindonut7777 ,

 

In complement here is a quick interactive video to discover the lovely Date Time Function: DateTime Functions 

Available with so many others in the Learn/Academy/ Interactive Lessons menu.

 

Hope it helps

 

Stéphane Portier
Sales Engineer
Alteryx
Ar13f
8 - Asteroid

Dear @StephaneP 

 

thanks for the info, i'll look into it for the session.

Labels