User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
itzikd
itzikd
Level III

convert a date from a number to date

Created: Oct 14, 2020 11:37 AM  |  Last Modified: Jun 10, 2023 4:20 PM (3488 views)

so i have a jsl data table that has dates like this: 04/09/2020 2:59:17 AM

when i save it to excel as xls file it saves it as 3675976666

so when i open it again in jmp, its a number as above, how can I transfer it back to the way it was in line number 1?

0 Kudos
1 REPLY 1
txnelson
Super User txnelson
Super User

Re: convert a date from a number to date

Oct 14, 2020 11:52 AM (3484 views)  |  Posted in reply to message from itzikd 10-14-2020
Go to the Column Info for the column and change the format to the Date format you want. JMP dates are just numeric columns with the numeric value being the number of seconds since Midnight, January 1, 1904. So that is the number you are seeing.
Jim

Recommended Articles