Choose Language Hide Translation Bar
Highlighted
JulieSAppel
Level IV

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
txnelson
Super User

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.

time.PNG

Jim

View solution in original post

1 REPLY 1
Highlighted
txnelson
Super User

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.

time.PNG

Jim

View solution in original post

Article Labels

    There are no labels assigned to this post.