change date format
Hi, I received an .xlsx data sheet with the following date "dd.mm.yy" in a column, i.e. "03.10.14".After copying the data into JMP I created a new column to get the numeric number for the date and converted the date into 1. a numeric date type with2. a ordinal modeling type and3. format to "yyyy-mm-dd". However, some dates "20.10.15" do not appear in my new column. Is there a defnition conflict?...