Subscribe Bookmark RSS Feed

Adding date and time columns

szfunh

Community Trekker

Joined:

Jul 10, 2015

I have a data set with a date column and a time column. In order to create a long date column, I tried using a simple formula to add those two columns, but for some rows the resulting date is in 2011 instead of 2015. This only happened for about 700 of the rows, with the other 16000 returning the correct year. Has anyone else experienced this?

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

I downloaded your attached data table, and changed the format on both your date and time columns to ddMonyyyy:h:m.  What it reveled is that many of your time values have a date based upon 31Dec1899, and not 01Jan1904.  I believe this is the issue.....

Jim
6 REPLIES
dlee0416

Community Trekker

Joined:

Jun 11, 2014

Can you supply a small sample of instances that worked as well as some that didn't?

szfunh

Community Trekker

Joined:

Jul 10, 2015

Forgive my ignorance, I'm new to these forums. How do I share a file with you?

txnelson

Super User

Joined:

Jun 22, 2012

Click on "Reply"

In the Upper right hand corner there is a selection that says "Used Advanced Editor", click on it

It will bring up an editing window that has an Attach button

Jim
szfunh

Community Trekker

Joined:

Jul 10, 2015

In this example, the long date on 9/28 is in 2011, while the long date on 9/29 is in 2015.

Solution

I downloaded your attached data table, and changed the format on both your date and time columns to ddMonyyyy:h:m.  What it reveled is that many of your time values have a date based upon 31Dec1899, and not 01Jan1904.  I believe this is the issue.....

Jim
szfunh

Community Trekker

Joined:

Jul 10, 2015

That's it! Thank you. I didn't realize that the times had an associated date.