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
I have again attached the table.
Please confirm me.
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" )
)
)
);
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.
I have again attached the table.
Please confirm me.