How to convert these kind of timestamp 2019-06-10T20:51:46+0000 into ''yyyy-mm-dd''.
I have tried many of format patterns but its not working.
Currently the data type of timestamp column is Character and modelling type is Nominal
Go to Solution
The easiest way to do this is with a new column with a formula.
The Informat() function will convert everything before the "T" and the Word() function makes it easy to extract just that portion.
More about dates and the Word() function:Using dates, times, datetimes and durations in JMP If you learn only one Formula Editor function, Word() is the one
View solution in original post