I am using a script to create a new column with a formula based on a date entered by a user in a dialog box. Using the code below the formula uses the variable "MyDate" instead of the value stored in it.
Re: Using a variable value in script created formula
May 3, 2010 3:42 PM(1097 views)
It works perfectly for me. What version of JMP and what platform (Windows?, Mac?, Linux?). When I enter 05May2009:4:00 PM in a Dialog Text Box this is the formula that gets generated: If(:DateTime lt 05May2009:16:00:00, "Yes", "No") with a less than symbol in place of the "lt". Here's the code I executed. I first tried it without a dialog and used the commented out line instead. They both work. Assumes a table is open with a DateTime column containing DateTimes.