Blank filter value in date filter

[Anonymous]

Hi guys,

i have a date filter that shows a blank filter option for the date range 01.01.2019 - 31.12.2019:

But when i change to 02.01.2019 - 31.12.2019 the blank value disappears: 

The relationship look like this:

1) Date table

2) Order table

3) Item table

Now i don't understand why for 01.02.2019 - 31.12.2019 the date filter shows a blank value but not for 02.01.2019 because if i look at the date table i don't see any blank values for 01.02.2019:

Thanks guys!

[Greg_Deckler · Accepted solution]

That generally means an unmatched value across a relationship.

[Anonymous]

Yes it comes through the last relation:

when i remove that one the blank field will also disappear. But i don't get how that causes the blank field. How can i fix this?

[Anonymous]

Hi @Anonymous ,

According to the direction of your relationship, you can't remove the blank field.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Yes true. I figured in the last table there are rows that can't be found in the table before. So for those rows the date from the date table can't be joined.

Thx guys!

[Syndicate_Admin]

I just encountered this problem, but the cause was different. I leave it here for future reference. In my case the targets in the date filter were due to the relationship between the date table and the data table. The date in both tables was of the "date time" type. The problem is that in the date table the data appears as "01-01-2021: 00:00:000.00" for example, while in the data table some dates were of the type "01-01-2021: 12:35:255.996" (due to the different origin of the data). Naturally, the relationship doesn't work. To fix it, both fields must be converted to the "date" type.

I hope it serves someone with a similar problem.