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

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
16 - Nebula

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
10 - Fireball

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
10 - Fireball

Dear @StephaneP 

 

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

Labels