Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

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

Change a non uniform String Field to Date Format

DataPirate26
9 - Comet

Hi all, 

 

Below I have shared a sample dataset in which the Hire Date field has dates which are written in various Forms and is not in Constant form. So I am unable to change it to the desired below given date format. 

 

I want to change this to given Date format ( dd-mon-yy) - 16-Sep-22 . Can someone help me with this ? 

4 REPLIES 4
grazitti_sapna
17 - Castor

@DataPirate26 , You can use regex for this. Please find my solution attached.

 

grazitti_sapna_0-1663302121466.png

 

Sapna Gupta
DataPirate26
9 - Comet

@grazitti_sapna Thanx for you quick help. This worked Fine absolutely. 

binuacs
17 - Castor

@DataPirate26 Another way of doing this with Contains function

 

binuacs_0-1663307796841.png

 

DataPirate26
9 - Comet

@binuacs absolutely this also works fine. 

Labels