nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

45157_en-US

liliconcom

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

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

Thanks txnelson, that worked perfectly.

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;

Comments

There are no comments yet

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Best Of