cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
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
Choose Language Hide Translation Bar
JulieSAppel
JulieSAppel
Level IV

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

Created: Mar 6, 2018 05:25 AM  |  Last Modified: Mar 30, 2018 11:18 AM (16855 views)

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

 

Test file date.jmp
0 Kudos
11 REPLIES 11
JulieSAppel
JulieSAppel
Level IV

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

Mar 15, 2018 09:10 AM (1343 views)  |  Posted in reply to message from txnelson 03-15-2018
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?
0 Kudos
JulieSAppel
JulieSAppel
Level IV

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

Mar 15, 2018 09:17 AM (1340 views)  |  Posted in reply to message from JulieSAppel 03-15-2018

No sorry it works now

Thanks for the help

0 Kudos