User Community
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: 

  • JMP Security Notice: CVE-2026-109618 and CVE-2026-109619

    JMP promptly initiated a review of its products, services, and relevant infrastructure for exposure to CVE-2026-109618 and CVE-2026-109619.

    Our assessment of JMP products has not identified exposure to these vulnerabilities. Where remediation was required within supporting environments, appropriate security updates and controls have been applied and validated.

    We have identified no evidence of successful exploitation or unauthorized access to JMP systems or customer information associated with these vulnerabilities.

    JMP continues to monitor the issue and relevant vendor guidance. No action is required by JMP customers at this time.

  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Graph Builder Toolbar streamlines interactive graphing. Creates shortcuts on Report and GraphBuilder Helpers toolbars. Download and install the extension.

JMP Wish List

We want to hear your ideas for improving JMP. Share them here.
Choose Language Hide Translation Bar

CSV import force MDY or DMY date format

Status: Acknowledged Submitted by Super User on ‎04-12-2024 07:10 PM
3 Comments (3 New)

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

 

@jules - 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.

3 Comments
hogi
Level XIII
‎07-04-2024 11:29 AM
‎07-04-2024 11:29 AM

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

hogi
Level XIII
‎10-03-2024 11:08 AM
‎10-03-2024 11:08 AM

one of the most kudoed "new" wishes.

hogi_0-1727986807668.png

 

Sarah-Sylvestre
Level V
‎05-14-2025 12:48 PM
‎05-14-2025 12:48 PM
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.