When creating a custom SQL expression in my elasticube I get the following message:
Object reference not set to an instance of an object
A similar statement runs properly in SQL but I cannot get it to work on Sisense. The difference is the last entry on the statement where it asked to return those where the current date is higher than today. We are looking for 13-31-9999 but when I write
c.prep_work_end_dt = '12-31-9999'
it doesn't work, so I changed to what you see in the screenshots and I get this error.
Please sign in to leave a comment.