Character Date to numeric dateI apologize because I see this question asked in other ways before but I can't seem to follow the solutions. Perhaps my date format is different enough and I'm not keen enough on scripting yet to figure out where I'm going wrong. I'm using JMP 17.
I've attached a simple table where you will see a column of Dates that looks like a correct format but JMP only recognizes it as character. I can change to numeric but when attempt to make it a m/d/y h:m type format then it reverts back to character. As a result I cannot get the column to sort properly.
How do I script this to modify from char to numeric m/d/y h:m type format?
Automation and ScriptingBasic Data Analysis and Modeling