This column is called end_date. this is how it is defined. I am using Netsmart myevolv and don't have access to the database itself but via a reporting system they have. How would I filter I don't want records with an end_date. I tried
is null, = ' ' but nothing is working.
end_date Data Type Character Length Numeric Precision Numeric Scale
DBTimeStamp 8 23 3
did you try and and or did you try an or
end_date is null or = ''
It doesn't like the or. it can do one or the other.
but neither of them are doing the filter
Are they using Date.MinValue for no end date such as 0001-01-01 ? Hard to provide an answer without knowing what the actual content in the data is