This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
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: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
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 07:20 PM (1258 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 (1254 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