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