I am attempting to filter on a date value using a constant for my date value. I get the exception: Expression cannot be null.Filter1 : Filter1.LowDate

Support Queries Astera Centerprise
,
1

Hi, I am attempting to filter on a date value using a constant for my date value. I get the exception: Expression cannot be null.Filter1 : Filter1.LowDate - Expression does not evaluate to data type Date. I attached an example using the SQL server Adventure Works database.

Community 2
Community 21232×677 114 KB

2

Hi, Sana.
Looks like on your LowDate field you have set the data type as Date whereas in the calculation you are getting Boolean values (true or false) with respect to how the low date and the transaction date compares. You will have to correct this to get past the error “Filter1.LowDate - Expression does not evaluate to data type Date”.
As for “Expression cannot be null”, you will have to provide the rules for filter on the next screen!
Hope this helps!