Hi all,
I am opening a csv file with dates (0000-00-00) having a default column data type character. However, whenever I tried to update the column with a formula from another column with a date value, I cannot change the format into date. My code looks something like this
dt = Open ("C:\Users\table1.jmp");
dt2 = Open ("C:\Users\table1.jmp");
dt2 << Update( With( dt),
Match Columns( :idFin = :idFin ),
Add Columns from Update Table( :Start_Date, :End_Date )
);
dt2:Name ("Actual Start Date") << Data Type( Numeric, Format( "y/m/d", 19 ));
dt2:Name ("Actual Start Date") << Set Formula( :Start_Date );
After having the formula (:Start_Date) on my Actual Start Date column, it doesn't change to y/m/d format but instead it has the Best format. Please help