convert number to date

Question

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?

patrick_rooney · Answer

Thank you, works great

txnelson · Answer

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))