cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • 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 will suspend normal business operations for our Rest and Recharge Day on Friday, October 2, 2026.
    Regular business hours will resume on Monday, October 5, 2026.

JMP Wish List

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

Add Parse Date as a New Formula Column option

It is sometimes safer to parse dates using a new column instead of changing the value in-place using an input format.  See discussion at Tricks to prevent incorrect input date formats from resulting in missing values?. Adding an option in the new formula column to parse that date using a format specified by the user would make this easier.

1 Comment
jthi
Super User

The platform is also almost there with the JMP16's Custom Date-Time Formatting with Format Patterns Youtube: Custom Date Formatting in JMP 16 . Not sure if you can do it directly with right-click New Formula column (don't have JMP16 on this PC to verify).