This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
Choose Language Hide Translation Bar
mallen810
mallen810
Level III

Combining several columns into a single column date/time

Sep 26, 2017 03:48 PM (3825 views)

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

0 Kudos
2 REPLIES 2
txnelson
Super User txnelson
Super User

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

Sep 26, 2017 04:01 PM (3820 views)  |  Posted in reply to message from mallen810 09-26-2017

The formula for you new column is

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

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

Sep 27, 2017 08:58 AM (3801 views)  |  Posted in reply to message from txnelson 09-26-2017

Thanks txnelson,  that worked perfectly.

0 Kudos