How to search and display records having custom DATE field is null?

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

Case: Is there a way in the search area that could display records which have a custom DATE field is empty?

I have other search criteria, but every time I have to use SORT to make records with empty DATE field on top, which is not very convenient.

2

You could set the date field up in studio as a date range. Go to studio -> cases -> fields -> your date field. Select “Enable Range Search” and press save.

This will allow select the drop down option in the advanced search for cases. You can then select this week, month, year to filter out the null values

3

Thank you!
BUT, I actually want the only NULL date to be displayed.
I checked the date range search, and there is no an option to select date=null

4

Hey Brucelee073,

Did you ever find a way of showing the NULL values?

Thanks,

Tom