I have numeric data in the form of, e.g., 8601representing 1/1986.
I want to convert it to a JMP data value in order to be able to do arithmetic on it.
I'm using the formula below and am getting dates in the 21st century (e.g., 2086 when I want 1986).
any help on changing the formula or a workaround to get the 20th century dates I want?
The solution is pretty easy. All that has to be done is to concatenate "19" to the front of the year value you are stripping off of ODATEW
Thank you, works great