cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
Creating a Timestamp Row for Logging Daily or Timed Activity

 

Let’s say you wanted to record daily activity in a JMP data table and would like to populate the date rows automatically

 

or need a “time stamp" which represents the time when the new data has been entered as new row.

 

In a Column, create the amount of rows as your planning for your observations. 

 

Right-click Add Rows - Enter 30.

 

Then create 2 rows of dates, today and tomorrow for example.

 

Highlight both of those dates, Right-click then Continue Sequence to end of Table.

 

The second way we will use the Today argument in the formula editor and format the column as a date and time.

 

I created a column, right-clicked for Formula ,  added the Today argument and selected OK.

 

I’ll manually enter a value and there is my date. However I don’t care for it;’s format.

 

Under Column Info I’ll format as Time with my date structure preference.

 

Now whenever I enter data a nice clean timestamp appears.

 

Enjoy using JMP and please stop by the the JMP Community to learn more.

Recommended Articles