Combining Date Column and Time Column to Create TimestampFor a data table with a date column and a time column, I create a new column that uses the formula Date + Time to create a timestamp. However the formula seems to work inconsistently where some of the timestamps result in being 4 YEARS previous than what they should be.
| Date | Time | Timestamp (formula) |
| 2021 - 10 - 01 | 12:05 AM | 10/01/2021 12:05 AM |
| 2021 - 10 - 23 | 6:59 PM | 10/23/2017 6:59 PM |
| 2021 - 11 - 07 | 7:45 PM | 11/07/2017 7:45 PM |
Is there a better way to generate a timestamp that avoids whatever causes this issue?
Data TableRe: Combining Date Column and Time Column to Create TimestampAssuming that your Date column and your Time column are JMP date/time values, my suggestion is that you need to change the display format for your 2 columns to display both date and time to see if the Time column contains date values In this example, Column 6 and Column 7 display the same time values,
however, when one examines the actual numeric values, they are completely different.
The Column 6 actually contains the date component , so what I am guessing is that in your time value, there are additional date related values
Re: Combining Date Column and Time Column to Create TimestampThanks for the explanation. When I changed the format of the Time column it showed different dates with one being the 01/01/1994 and the other 12/31/1899. The raw data that is pulled into JMP lists the time only, so I am unclear how the date is "assigned" to the times. How can I address the discrepancy, so that the dates are consistent in the time columns?
