cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
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.