Subscribe Bookmark RSS Feed

Combining several columns into a single column date/time

mallen810

Contributor

Joined:

Dec 9, 2016

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
txnelson

Super User

Joined:

Jun 22, 2012

The formula for you new column is

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

Contributor

Joined:

Dec 9, 2016

Thanks txnelson,  that worked perfectly.