cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • DownloadSemiconductor Toolkit: Tools to create wafer maps, add wafer geometry to graphics, explore die defects & compare wafers.
  • Discovery Summit 2026: Early User Edition - September 23-24.Register. It's free.
  • Use JMP Clinical with CDISC-compliant data. Review studies, ID safety and efficacy signals & communicate findings with interactive graphics. Register to see how. Aug. 27, 2 pm US ET.

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).