Regarding change in data format

[#1]

Hello All,

I have a lot table with a date column in which date are mentioned in two different format like 10/27/2016 & 27-10-2016. I want to put them on another column with a single format to plot the variability chart.

Your suggestion will be helpful.

Pushpendra 

[#2]

Here is a script that will work for you

Names Default To Here( 1 );
dt = Current Data Table();

// Assuming the date column to be read is called "Text Date" the following will work
dt << New Column( "Date",
	Format( m / d / y ),
	formula(
		If( Contains( :Text Date, "-" ),
			Informat( :Text Date, "dd/mm/yyyy" ),
			Informat( :Text Date, "mm/dd/yyyy" )
		)
	)
);

[#3]

Hello Jim,

Thank you for the solution.

I have tried your scrip but didn't get the resuls.

I have attached my table into which  operation will be performed.

Could you please try your script on this table.

[#4]

I can not find your attached table

[#5 · Accepted solution]

I have again attached the table.

Please confirm me.