Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here

Date is inconsistent format

7 - Meteor

The date column multiple formats have  dd/mm/yyyy hh:mm:ss , mm/dd/yyyy hh:mm:ss ,dd-mm-yyyy hh:mm:ss and mm-dd-yyyy hh:mm:ss

 I want the date format in mm/dd/yyyy hh:mm:ss. Could you please help me on this

16 - Nebula
16 - Nebula



While it is easy to deal with the - vs / issue, it is very hard to deal with mm/dd vs dd/mm automatically as there is no way to tell the difference between 06/12 mean 6th December of 12th June.


You can create a rule for it if you know which one is more likely.


Using a formula tool:


	iif( ToNumber(left([Input],2)) < 13,
		"%m/%d/%Y %H:%M:%S",
		"%d/%m/%Y %H:%M:%S")


will parse all the ones which try month day format if the first two digits are between 1 and 12, regardless of the separator.


Could you post some sample data?



7 - Meteor

Hi @jdunkerley79 ,



Thanks for response and sorry for late reply


04/07/2020 14:40:40 PM

16/04/2020 15:50:40 PM