nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

746985_en-US

liliconcom

CSV import force MDY or DMY date format

What inspired this wish list request? https://community.jmp.com/t5/Discussions/csv-file-Day-Month-Year/m-p/746980#M92639

What is the improvement you would like to see? add preference and option to CSV import to prevent guessing the date format

Why is this idea important? it is hard to tell it is wrong; dates may get corrupted

@julian - the open(...csv) uses a guess that can get the wrong answer if there are no dates in a column that are unambiguously DMY, 14/3/2024 is unambiguous but 12/3/2024 is not. The guess will be MDY if there is no date with a month>12.

Data Access

Data Blending and Cleanup

Re: CSV import force MDY or DMY date format

related wish: Preferences for Standard Date format (from 2017 - archived in 2022)

Re: CSV import force MDY or DMY date format

one of the most kudoed "new" wishes.

Re: CSV import force MDY or DMY date format - Status changed to: Acknowledged

Thank you for submitting this request Craige! And thank you to other users for showing your support. This is being reviewed and I will update this wish if there are any changes.

Comments

There are no comments yet