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
0 Kudos

is date() function

## Problem to Solve

Many times I can't tell the difference between a date and a number in that range.  I can check the format of a column, but if I'm just holding a date value it can be a problem.  


## Possible Solution

As date() says that it marks a date time value internally for output purposes.  I'm wondering if it would be possible to just have all date time formats use this value.  Plus it would have the benefit of having dt:datetime[1] return a human readable output.  
If all date time jmp values used this internal value, IsDate() could just check that value.  

 

I obviously could be way oversimplifying it in my brain.  

 

 

1 Comment
Ryan_Gilmore
Community Manager
Status changed to: Archived
We are archiving this request. If this is still important please comment with additional details and we will reopen. Thank you!