My table structure is more or less as follows (projects)
Title Start date End date
Proj A 01.01.2018 31.12.2018
Proj B 01.01.2018 30.04.2019
Proj C 01.09.2018 31.01.2019
Now I would need to have a filter of the data by year (not the full date). In the above scenario, I need to be able to get "Proj B" and "Proj C" returned if I select either 2018 or 2019 as my filter/slicer.