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: 
Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
Choose Language Hide Translation Bar
Highlighted
itzikd
itzikd
Level I

convert a date from a number to date

Oct 14, 2020 8:37 AM (120 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
Reply
1 REPLY 1
Highlighted
txnelson
Super User txnelson
Super User

Re: convert a date from a number to date

Oct 14, 2020 8:52 AM (116 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
Reply
Article Labels