topic Re: Combine Date Column and Time Column to "DateTime" in Discussions

Combine Date Column and Time Column to "DateTime"

yanee — Fri, 16 Feb 2024 05:04:03 GMT

Hi,

I imported data from the .xls file. There is a "Date" column and "Time" column. I have to create a new column with Date Time Combine.

I used below formula

Date MDY( Month( :Date ), Day( :Date ), Year( :Date ) ) + (Hour( :Time ) * 3600 + Minute( :Time ) * 60 + Second( :Time ))

Some rows the output is off by roughly 1 minute but some rows are correct.

How Can I fixed this?

Re: Combine Date Column and Time Column to "DateTime"

jthi — Fri, 16 Feb 2024 05:38:40 GMT

If your date and time columns are correctly formatted (other has just date and other just time) you should just be able to add them together without any other calculations.

Re: Combine Date Column and Time Column to "DateTime"

Thierry_S — Fri, 16 Feb 2024 05:41:25 GMT

Hi,

It seems that there is an easier formula. You can simply define the DateTime column as:

:Date + :Time

Then, set the format to "m/d/y h:m:s".

This may not solve your problem since the data import from Excel may have odd behaviors, but I would give it a try.

If the problem persists, I would check that the data you imported is valid by converting your Time column to Numeric - Best format and check that the same times are coded by the same number of seconds.

Let us know if it works.

Best

Re: Combine Date Column and Time Column to "DateTime"

txnelson — Fri, 16 Feb 2024 05:42:46 GMT

You should be able to just add the 2 values together

:date + :time;