cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar

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.

2 Comments
hogi
Level XII

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

hogi
Level XII

one of the most kudoed "new" wishes.

hogi_0-1727986807668.png