https://community.jmp.com/t5/Discussions/Date-Import-Fix-M-D-Y-h-m-s-to-D-M-Y-h-m-s/m-p/523293#M74807 <P>Is the anyway to reassign which figures are date and month - 07/05/2022 10:24:21. The column is formatted&nbsp;D/M/Y h:m:s but the date is actually 05th of July.</P><P>&nbsp;</P><P>Messed up 1 data sheet in Excel and concatenating to ones that are correct - please help!</P> Sat, 10 Jun 2023 23:51:17 GMT DELANDJ1985 2023-06-10T23:51:17Z https://community.jmp.com/t5/Discussions/Date-Import-Fix-M-D-Y-h-m-s-to-D-M-Y-h-m-s/m-p/523293#M74807 <P>Is the anyway to reassign which figures are date and month - 07/05/2022 10:24:21. The column is formatted&nbsp;D/M/Y h:m:s but the date is actually 05th of July.</P><P>&nbsp;</P><P>Messed up 1 data sheet in Excel and concatenating to ones that are correct - please help!</P> Sat, 10 Jun 2023 23:51:17 GMT https://community.jmp.com/t5/Discussions/Date-Import-Fix-M-D-Y-h-m-s-to-D-M-Y-h-m-s/m-p/523293#M74807 DELANDJ1985 2023-06-10T23:51:17Z https://community.jmp.com/t5/Discussions/Date-Import-Fix-M-D-Y-h-m-s-to-D-M-Y-h-m-s/m-p/523317#M74812 <P>If you have already "messed up" as in the data is wrong, you could maybe try method used here<LI-MESSAGE title="Date Conversion issue" uid="519704" url="https://community.jmp.com/t5/Discussions/Date-Conversion-issue/m-p/519704#U519704" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"></LI-MESSAGE> . First change the column to character column -&gt; back to numeric -&gt; change to correct format/use format pattern to fix the data.</P> Tue, 19 Jul 2022 11:29:15 GMT https://community.jmp.com/t5/Discussions/Date-Import-Fix-M-D-Y-h-m-s-to-D-M-Y-h-m-s/m-p/523317#M74812 jthi 2022-07-19T11:29:15Z