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: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
DELANDJ1985
DELANDJ1985
Level III

Date Import Fix - M/D/Y h:m:s to D/M/Y h:m:s

Created: Jul 19, 2022 07:00 AM  |  Last Modified: Jun 10, 2023 4:51 PM (724 views)

Is the anyway to reassign which figures are date and month - 07/05/2022 10:24:21. The column is formatted D/M/Y h:m:s but the date is actually 05th of July.

 

Messed up 1 data sheet in Excel and concatenating to ones that are correct - please help!

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User jthi
Super User
Solution

Re: Date Import Fix - M/D/Y h:m:s to D/M/Y h:m:s

Jul 19, 2022 07:29 AM (713 views)  |  Posted in reply to message from DELANDJ1985 07-19-2022

If you have already "messed up" as in the data is wrong, you could maybe try method used hereDate Conversion issue . First change the column to character column -> back to numeric -> change to correct format/use format pattern to fix the data.

-Jarmo

View solution in original post

1 REPLY 1
jthi
Super User jthi
Super User
Solution

Re: Date Import Fix - M/D/Y h:m:s to D/M/Y h:m:s

Jul 19, 2022 07:29 AM (714 views)  |  Posted in reply to message from DELANDJ1985 07-19-2022

If you have already "messed up" as in the data is wrong, you could maybe try method used hereDate Conversion issue . First change the column to character column -> back to numeric -> change to correct format/use format pattern to fix the data.

-Jarmo