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?
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.....
Can you supply a small sample of instances that worked as well as some that didn't?
Forgive my ignorance, I'm new to these forums. How do I share a file with you?
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
In this example, the long date on 9/28 is in 2011, while the long date on 9/29 is in 2015.
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.....
That's it! Thank you. I didn't realize that the times had an associated date.