224322_en-US

liliconcom

date time combination discrepancy

Hi,

 

I wanted to combine a date column with a time column but when I do so the resulting column shows a 4 year discrepancy. Is it a leap year thing or what am I missing? And how can I fix it?

 

Br Julie

Re: date time combination discrepancy

Your Time column is not just a time value(i.e. number of seconds since midnight).  But it is a Date/Time value from the year 1899.  4 years before the 1904 zero base that JMP uses.