How to solve if database raw data has null value

Question

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

Mark_Bailey · Answer

Modify the query so the WHERE clause checks for non-null Date records? Try pushing the problem back to the source of it.

briancorcoran · Answer

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