transform column

[#1]

Hello everyone, I have a problem when I want to transform this column into a date. I transform it in Numeric then in date but when I transform it in date the year becomes 1904 and I don't know why?

[#2]

You could try creating a formula column with Informat() and then format that as you want. If the start value isn't character add Char() around the column reference

Informat("20210408", "YYYYMMDD");

Informat(Char(:ColumnToConvert), "YYYYMMDD");

[#3]

I know but when I do,  nothing happens

[#4]

Try

column(dt, "Operation Start Date" ) << Input Format( "yyyymmdd");

[#5 · Accepted solution]

Create new formula with the formula I provided earlier, you should end up with something like this:

Then change the Format to what fits you best

You can do this in place, but I would suggest:

1. Creating new formula column
2. Changing Format
3. Verifying everything works as you want to
4. Deleting old column if you don't need it
5. Renaming new column

If you have to do this often, then I would look into using JSL and scripting it (I think Activity Recorder/Enhanced Log in JMP16 can record all of these steps to make scripting very simple).

[#6]

The reason is that JMP uses seconds since 12:00 AM January 1, 1904, as its base for time values. Your numbers are integers that code the year, month, and day. JMP has many built-in functions for working with date and time values. That is why @jthi's solution is so simple.

[#7]

@jthi and @Mark_Bailey have given you some good information. If you'd like to know more about how JMP handles dates see: Using dates, times, datetimes and durations in JMP