Forum Discussion
Exclude records where date is null when filtering by date range
I have a date range like this I want to see the list of all courses (in a matrix table with information like Course, Email, Assigned at, Started at etc ) that were started within that specifi...
Uzi2019
Community Champion
Community ChampionHi Anonymous
You can simply select all then uncheck the blank box like below under filter on visual.
" In your case please select the date in visual filter"
I hope I answered your question Please give Kudos and accept it as a solution.
Thanks!
You missed this point
"PS: I want the rows with the null dates (started at and other dates) in the table, just not when a filter is applied"
I want those rows in the table just not when a date filter is applied like in this case 'Started at'. So when no date range is selected the table SHOULD have the rows where any date is null as well.