I have issues with filters on custom fields (date type).
As you can see below, there is a filter on field PM konec smlouvy
however, you can see, that in this subset, there is a blank row and rows, which date is not in 3 months.
What are you going to do about that pipedrive team 
?
I asked the support, we were able to identify, that when you delete date and the field is blank - in the database stays actualy 0000:00:00. Which I still do not understand why it is in the filter. Maybe I am just missing some understanding.
Comments
-
I see, so I partially did not understood - I fixed it by defining lower boundary (I only want to see range from today till 3 months in advance because of automation). This eliminated all things above - but still you should keep in mind, that if someone deletes date from field, it does not become NA, but 0000:00:00 - something like that.
0 -
Martin Pecha said:
I see, so I partially did not understood - I fixed it by defining lower boundary (I only want to see range from today till 3 months in advance because of automation). This eliminated all things above - but still you should keep in mind, that if someone deletes date from field, it does not become NA, but 0000:00:00 - something like that.
Hi @Martin Pecha , I'm glad you figured out the condition that was missing so you could filter the exact results you were looking for!
Thank you for bringing this to our attention. I've reached out directly to the PM so the team can look into it, as I'm sure Support has also flagged it internally. We appreciate your feedback!
0
