https://community.jmp.com/t5/Discussions/extract-year-from-a-mdy-variable/m-p/340#M340 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?<BR />Thanks,<BR />mgm Tue, 31 Mar 2009 16:34:03 GMT 2009-03-31T16:34:03Z https://community.jmp.com/t5/Discussions/extract-year-from-a-mdy-variable/m-p/340#M340 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?<BR />Thanks,<BR />mgm Tue, 31 Mar 2009 16:34:03 GMT https://community.jmp.com/t5/Discussions/extract-year-from-a-mdy-variable/m-p/340#M340 2009-03-31T16:34:03Z https://community.jmp.com/t5/Discussions/extract-year-from-a-mdy-variable/m-p/341#M341 Year() will work if your variable is a numeric date, but if it's a character date, you'll have to parse it first.<BR /><BR />Year(Parse Date( "07/15/2000" )) Wed, 01 Apr 2009 13:19:53 GMT https://community.jmp.com/t5/Discussions/extract-year-from-a-mdy-variable/m-p/341#M341 XanGregg 2009-04-01T13:19:53Z