16730_en-US

liliconcom

convert number to date<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

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?

Re: convert number to date

Thank you, works great

Re: convert number to date

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