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

Highlighted
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

Highlighted
16 - Nebula
16 - Nebula

Hi,

 

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:

 

DateTimeParse(
	[Input],
	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?

 

 

Highlighted
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

Labels