convert number to date

[#1]

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?

[#2]

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

Date MDY(Num("19"||Right(Char(ODATEDW),2)),1,Num(Left(Char(ODATEDW),2))

[#3]

Thank you, works great