Filter with empty date

[laurent_plichta]

Hello gurus

I want to filter query with a datum type caracteristic,

but I want just empty date like #

Excel displays # but I can't select # value for a date type

Can you help me ?

[jaya_mogali · Accepted solution]

Hi Laurent,

after you restrict the characteristic and go to selection for date Type "#" in the box below (left of serach ICon) and use arrows to move selection box.

Jaya