Date format issue when pasting from clipboard as "Paste with Column Names" (Day and Month swapped)
Hi everyone,
I am having trouble pasting data from the clipboard into JMP. My source data uses the European date format (DD.MM.YYYY).
When I paste the data, JMP misinterprets the dates using the US format (MM.DD.YYYY). For example, 04.05.2026 (May 4th) is incorrectly imported as April 5th. This happens for all days below the 13th of a month. And the column is formated as Nominal.
Is there a way ...