AnsweredAssumed Answered

Filter on empty date in ListView

Question asked by Neil Conacher on May 22, 2018
Latest reply on Jun 5, 2018 by Neil Conacher

When building a filter in ListView, the date field filter options do not include Is Empty/Is Not Empty options (as it does in Reports)

 

Sugar Support have logged this as a defect/enhancement

 

Does anyone have a way of dealing with this. It is a basic business requirement to list records which don't have a date field completed.

 

My specific requirement involves a number of date fields so I want to avoid creating a custom calculated field (which would be an option if only one field involved) which I could filter on (eg date present)

 

Thanks 

Outcomes