I have a script to pull data from a range of dates, which works.
Now, I want to edit it to pull another set of dates, however some data have null date values in the database server which causes the JMP software to crash everytime the script runs.
Anyone have solutions for this?
SQLA = "SELECT PalletizedDate, Line, Serial, CTI_Date
FROM [dbo].[v_ModulePowerCellCTI] WHERE (LINE LIKE 'LineSelect') AND (CTI_Date BETWEEN 'DateBegin' AND 'DateStop') ";
SQL1 = Substitute(SQLA, expr(LineSelect), Linename, expr(DateBegin), startdate, expr(DateStop), enddate);
Modify the query so the WHERE clause checks for non-null Date records? Try pushing the problem back to the source of it.
If you are getting a crash in JMP, please submit this to support@jmp.com so development can look into the issue.
Thank you for your help,
Brian Corcoran
JMP Development
