cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
mallen810
Level III

Combining several columns into a single column date/time

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.

Screen Shot 2017-09-26 at 3.40.26 PM.png

2 REPLIES 2
txnelson
Super User

Re: Combining several columns into a single column date/time

The formula for you new column is

Date MDY(:Month,:Day,:Year)+:hour*3600+:Minute*60:Second;
Jim
mallen810
Level III

Re: Combining several columns into a single column date/time

Thanks txnelson,  that worked perfectly.

Recommended Articles