882759_en-US

liliconcom

Timestamp question

Hello,

I am challenged by the removal of a timestamp in a cell. See example. 01/07/2025 12:00:00 AM

I want to remove the 12:00:00 AM and achieve this  01/07/2022.

Thank you in advance for your assistance.

Data Exploration and VisualizationRe: Timestamp question

All you need to do is to change the display format for your column.

JMP date/time values are a numeric value of the number of seconds since 12 AM Jan 1, 1904.  

Therefore, JMP's numeric value for 01/07/2025 12:00:00 AM is the same as the numeric value of 01/07/2025

withTime = informat("01/07/2025 12:00:00 AM","m/d/y h:m:s");
show(format(withTime,"fixed dec",12,2));
onlyDate = informat("01/07/2025","m/d/y");
show(format(onlyDate,"fixed dec",12,2));

Format(withTime, "fixed dec", 12, 2) = "3819052800.0";
Format(onlyDate, "fixed dec", 12, 2) = "3819052800.0";

Just change the format of the column to m/d/y and you will have what you want.

Re: Timestamp question

In addition to the response already given, it is possible to remove the time of day; in your case 12:00:00; from a date using JSL:

:Date - Time Of Day( :Date )

All that remains to do is the changing of the column format:

See also the example attached.

 

Re: Timestamp question

And in more general remove the date of time from the timestamp. If we assume you have correctly formatted data in column called TIMESTAMP, you can use quick formula from right click menu

And it will give you the formula you would use

:TIMESTAMP - Time Of Day(:TIMESTAMP)

You can verify that values have changed by changing the format to Best