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

extract year from a mdy variable

Mar 31, 2009 12:34 PM (3310 views)
I have variable collection.date, in m/d/y format, and I want to create another variable, yr, by extracting year from collection.date. I have tried using the year function in a formula but haven't had any success. Any suggestions?
Thanks,
mgm
0 Kudos
1 REPLY 1
XanGregg
Staff XanGregg
Staff

Re: extract year from a mdy variable

Apr 1, 2009 09:19 AM (3277 views)  |  Posted in reply to message from 03-31-2009
Year() will work if your variable is a numeric date, but if it's a character date, you'll have to parse it first.

Year(Parse Date( "07/15/2000" ))