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: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
itzikd
itzikd
Level II

convert a date from a number to date

Created: Oct 14, 2020 11:37 AM  |  Last Modified: Jun 10, 2023 4:20 PM (1903 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 (1899 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