JMP script error

KST-CPT

Name Unresolved: runEndDate in access or evaluation of 'runEndDate' , runEndDate/*###*/

 

occurs when this code is enabled:

consrow = DateRange << Get Rows Where( :Main Error Code == "Consecutive die vision failure" );

waitrow = consrow-1;

gorow = consrow+6;

 

waitTime = :Time[waitrow];

waitDate = :Date[waitrow];

goTime = :Time[gorow];

goDate = :Date[gorow];

　

Bdt = New Table("Consecutive Failure Calc",

New Column("waitDate", Continuous, numeric, format("m/d/y"),values(waitDate)),

New Column("waitTime", Continuous, numeric, format("h:m:s"),values(waitTime)),

New Column("goDate", Continuous, numeric, format("m/d/y"),values(goDate)),

New Column("goTime", Continuous, numeric, format("h:m:s"),values(goTime)),

New Column("DownTime", Continuous, numeric, format("hr:m:s"), Formula(

(:goTime - :waitTime);

))

);

Bdt << SetName("Cons Time Table");

Bdt << clear row states;

 

Really only when the creation of the new data table is enabled.  Code is much longer than these line, but it works when I don't try to create this table, which I need.  Any help would be appreciated.

 

Thanks

uday_guntupalli

@KST-CPT, 
        In order for anyone to help you, I would request you to kindly take some time to please write your question in a little more detail and format your code. I understand you have a long code, in the piece of code that you have shared, I can't even see runEndDate anywhere. So without understanding what comes before or after this code, it is really hard for anybody to jump in and try to help you. 

        So, when you respond, would request you: 

1. Provide sample data if possible 

2. Provide sample code  or entire code if possible (or atleast provide context on what you are trying to acheive) 

3. When you share code, please kindly provide it using "insert code" or "insert JSL script" to make it more readable