Changing Chars to Time format -column properties and informat does not work-

saitcopuroglu

Dear community,

I guess importing from excel almost every time comes with formatting issues. Checked the discussions before I open this discussion and as I can see most of the cases have been solved by just simply changing the column properties to num-date format or just simply using informat. First turns a blank column, second does not work for me and with my weak knowledge. Table is attached and need to turn the "date" column to date format. (Using 13.1 on a mac)

Any help would be appreciated..

 

tsrevised.jmp

Justin_Chilton

One way to do this is to use a function like Date DMY and grab each individual peice of your date using the Word function. Informat will not work for you because "dd.mm.yyyy" is not a valid format.

 

Date DMY(
	Num( Word( 1, :Date, "." ) ),
	Num( Word( 2, :Date, "." ) ),
	Num( Word( 3, :Date, "." ) )
)

You may also want to check out the Data Table Tools Add-In. It has a Custom Date Writer within it that you can find details about here. The formulas it creates are not necessarily the simplest to understand, but they do provide the desired output.