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. The script looks like this: Informat( :New_Date, "yyyymmdd" ) New_Date is the name of the column. I ended up with a blank column. Tried to convert New_Date to string using Char(New_Date). That returns dots. Cannot understand why such a simple task could not be completed. BTW, I don't know JSL and used the formula tool
Thanks!
Since you make the "New Date" column a character string, using this formula should work:
It assumes that the day is always two characters (so the first would be 01), month is always two characters, and the year is always 4 characters.
Here is an example where the column values(in this case only one row is populated) are numeric and in the structure you have indicated.
To change this to a proper JMP date/time column here is how I would do it.
First open the Column Info dialog for the column in question
In able for JMP to recognize this using an Informat which will convert the 20001101 to a Date/Time value, the input column needs to be character, so change the Data Type to Character and click on Apply
Now go back to the open Col Info dialog box, and change the Data Type to Numeric, and select the Format, "yyyymmdd" from the list of formats. Once again, click on Apply
Note in the above image that the displayed value remains the same. This is because the display format is "yyyymmdd". Also notice the column has been changed back to Numeric.
To validate that it is a true JMP Date/Time column, you can change the display format to a different Date format. So go back to the Col Info dialog box, and select a different Date format. In my example, the "m/d/y" format is selected. Then click on apply
As can be seen, the correct Date is displayed as 01/11/2000.
Now just click on OK, and the column is converted as you want.
