topic Adding date and time columns in Discussions https://community.jmp.com/t5/Discussions/Adding-date-and-time-columns/m-p/16154#M14734 <HTML><HEAD></HEAD><BODY><P>I have a data set with a date column and a time column. In order to create a long date column, I tried using a simple formula to add those two columns, but for some rows the resulting date is in 2011 instead of 2015. This only happened for about 700 of the rows, with the other 16000 returning the correct year. Has anyone else experienced this?</P></BODY></HTML> Thu, 07 Jan 2016 16:49:15 GMT szfunh 2016-01-07T16:49:15Z Adding date and time columns https://community.jmp.com/t5/Discussions/Adding-date-and-time-columns/m-p/16154#M14734 <HTML><HEAD></HEAD><BODY><P>I have a data set with a date column and a time column. In order to create a long date column, I tried using a simple formula to add those two columns, but for some rows the resulting date is in 2011 instead of 2015. This only happened for about 700 of the rows, with the other 16000 returning the correct year. Has anyone else experienced this?</P></BODY></HTML> Thu, 07 Jan 2016 16:49:15 GMT https://community.jmp.com/t5/Discussions/Adding-date-and-time-columns/m-p/16154#M14734 szfunh 2016-01-07T16:49:15Z Re: Adding date and time columns https://community.jmp.com/t5/Discussions/Adding-date-and-time-columns/m-p/16155#M14735 <HTML><HEAD></HEAD><BODY><P>Can you supply a small sample of instances that worked as well as some that didn't? </P></BODY></HTML> Thu, 07 Jan 2016 19:09:33 GMT https://community.jmp.com/t5/Discussions/Adding-date-and-time-columns/m-p/16155#M14735 DaveLee 2016-01-07T19:09:33Z Re: Adding date and time columns https://community.jmp.com/t5/Discussions/Adding-date-and-time-columns/m-p/16156#M14736 <HTML><HEAD></HEAD><BODY><P>Forgive my ignorance, I'm new to these forums. How do I share a file with you?</P></BODY></HTML> Fri, 08 Jan 2016 15:12:57 GMT https://community.jmp.com/t5/Discussions/Adding-date-and-time-columns/m-p/16156#M14736 szfunh 2016-01-08T15:12:57Z Re: Adding date and time columns https://community.jmp.com/t5/Discussions/Adding-date-and-time-columns/m-p/16157#M14737 <HTML><HEAD></HEAD><BODY><P>Click on "Reply"</P><P>In the Upper right hand corner there is a selection that says "Used Advanced Editor", click on it</P><P>It will bring up an editing window that has an Attach button</P></BODY></HTML> Fri, 08 Jan 2016 15:18:11 GMT https://community.jmp.com/t5/Discussions/Adding-date-and-time-columns/m-p/16157#M14737 txnelson 2016-01-08T15:18:11Z Re: Adding date and time columns https://community.jmp.com/t5/Discussions/Adding-date-and-time-columns/m-p/16158#M14738 <HTML><HEAD></HEAD><BODY><P>In this example, the long date on 9/28 is in 2011, while the long date on 9/29 is in 2015.</P></BODY></HTML> Fri, 08 Jan 2016 15:23:17 GMT https://community.jmp.com/t5/Discussions/Adding-date-and-time-columns/m-p/16158#M14738 szfunh 2016-01-08T15:23:17Z Re: Adding date and time columns https://community.jmp.com/t5/Discussions/Adding-date-and-time-columns/m-p/16159#M14739 <HTML><HEAD></HEAD><BODY><P>I downloaded your attached data table, and changed the format on both your date and time columns to ddMonyyyy:h:m.&nbsp; What it reveled is that many of your time values have a date based upon 31Dec1899, and not 01Jan1904.&nbsp; I believe this is the issue.....</P></BODY></HTML> Fri, 08 Jan 2016 15:44:29 GMT https://community.jmp.com/t5/Discussions/Adding-date-and-time-columns/m-p/16159#M14739 txnelson 2016-01-08T15:44:29Z Re: Adding date and time columns https://community.jmp.com/t5/Discussions/Adding-date-and-time-columns/m-p/16160#M14740 <HTML><HEAD></HEAD><BODY><P>That's it! Thank you. I didn't realize that the times had an associated date.</P></BODY></HTML> Fri, 08 Jan 2016 15:58:48 GMT https://community.jmp.com/t5/Discussions/Adding-date-and-time-columns/m-p/16160#M14740 szfunh 2016-01-08T15:58:48Z