Discussions

Solve problems, and share tips and tricks with other JMP users.

Choose Language Hide Translation Bar

Level I

Created: Oct 19, 2021 03:05 AM | Last Modified: Jun 10, 2023 4:38 PM (2528 views)

I tried the formula scripts posted in other threads with no luck. How to convert timestamp in character to numeric datetime?

Pro_DF_2021_0-1634626970198.png

1 REPLY 1

Super User

Super User

Created: Oct 19, 2021 06:42 AM | Last Modified: Oct 19, 2021 3:43 AM (2515 views) | Posted in reply to message from Pro_DF_2021 10-19-2021

Create a new column
Go into the Col Info dialog and set the format and informat values txnelson_0-1634640004507.png
Enter the following formula for the new column to convert the character column to a JMP Date Time value
```
Informat( Word( 1, :timestamp, "U" ), "yyyy-mm-dd-Thh:mm:ss" )
```
txnelson_2-1634640223308.png

Jim