Created:
Jan 7, 2016 11:49 AM
| Last Modified: Jan 7, 2016 8:49 AM(12889 views)
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?
Created:
Jan 8, 2016 10:44 AM
| Last Modified: Jan 8, 2016 7:44 AM(16013 views)
| Posted in reply to message from szfunh 01-08-2016
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.....
Created:
Jan 8, 2016 10:44 AM
| Last Modified: Jan 8, 2016 7:44 AM(16014 views)
| Posted in reply to message from szfunh 01-08-2016
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.....