+2

Search for empty dates

Robrecht Belien 5 years ago in Home Portal updated by Mateusz Trzeciak (XTRF Deployment & Training Specialist) 5 years ago 1

Hi,

Is there a possibility to use filter on a date field to select all items that don(t have a date filled in?

For example search all projects where the actual startdate is empty?


Hi Robert,

there's no out of the box possibililty to apply such a filter. I believe this would require a custom field & a macro.
But a workaround form the top of my head would be to:

a) in your projects view add a column Actual start date and time
b) filter records descending by Actual start date and time column

This way projects with empty Actual start date and time will display first.