How to convert a numeric column to a date column correctly?
Hi,I have a date column in the format "yyyymmdd". An example date looks like this: 20000111. When I import data from a csv into JMP, this column is treated as numeric, continuous. I set its format to be date-yyyymmdd and realized that it was treated as 20000111 seconds past 1904/1/1. I changed the column to character, nominal and tried to use informat() to convert it but just cannot get it to work...