https://community.jmp.com/t5/Discussions/Combining-several-columns-into-a-single-column-date-time/m-p/45158#M25813 <P>The formula for you new column is</P> <PRE><CODE class=" language-jsl">Date MDY(:Month,:Day,:Year)+:hour*3600+:Minute*60:Second;</CODE></PRE> Tue, 26 Sep 2017 20:01:48 GMT txnelson 2017-09-26T20:01:48Z https://community.jmp.com/t5/Discussions/Combining-several-columns-into-a-single-column-date-time/m-p/45157#M25812 <P>I have imported some data from our sql server and it brings in the dates and times in six different columns. I want to combine all these columns into a single date/time column for graphing purposes. Any insight into this would be greatly appreciated.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 2017-09-26 at 3.40.26 PM.png" style="width: 662px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/7787iA5E6CAF3F35EA488/image-size/large?v=v2&amp;px=999" role="button" title="Screen Shot 2017-09-26 at 3.40.26 PM.png" alt="Screen Shot 2017-09-26 at 3.40.26 PM.png" /></span></P> Tue, 26 Sep 2017 19:48:20 GMT https://community.jmp.com/t5/Discussions/Combining-several-columns-into-a-single-column-date-time/m-p/45157#M25812 mallen810 2017-09-26T19:48:20Z https://community.jmp.com/t5/Discussions/Combining-several-columns-into-a-single-column-date-time/m-p/45158#M25813 <P>The formula for you new column is</P> <PRE><CODE class=" language-jsl">Date MDY(:Month,:Day,:Year)+:hour*3600+:Minute*60:Second;</CODE></PRE> Tue, 26 Sep 2017 20:01:48 GMT https://community.jmp.com/t5/Discussions/Combining-several-columns-into-a-single-column-date-time/m-p/45158#M25813 txnelson 2017-09-26T20:01:48Z https://community.jmp.com/t5/Discussions/Combining-several-columns-into-a-single-column-date-time/m-p/45173#M25823 <P>Thanks txnelson, &nbsp;that worked perfectly.</P> Wed, 27 Sep 2017 12:58:38 GMT https://community.jmp.com/t5/Discussions/Combining-several-columns-into-a-single-column-date-time/m-p/45173#M25823 mallen810 2017-09-27T12:58:38Z