cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
JulieSAppel
Level IV

How do I convert a numeric "string" into a date?

I´m a new user and I´m trying to convert a nummeric string into a jmp date format. 

I tried creating a new column by concatenating a character string so that could at least get my desired "ddmmyyy" output:

(Substr( :START_DATE, 7, 2 ) || Substr( :START_DATE, 5, 2 )) ||Substr( :START_DATE, 1, 4 ) but that didnt get´me any further.

Any ideas on this?

jpeg.PNG

 

11 REPLIES 11
JulieSAppel
Level IV

Re: How do I convert a nummeric string into a date?

Actually, when I run it on the test file I get missing data in all of the rows. I use JMP 12 - can that be the reason?
JulieSAppel
Level IV

Re: How do I convert a nummeric string into a date?

No sorry it works now

Thanks for the help