I have issues with filters on custom fields (date type).

As you can see below, there is a filter on field PM konec smlouvy 

image

however, you can see, that in this subset, there is a blank row and rows, which date is not in 3 months. 

image

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.

5f3d3a76f077983c9f8fc1ad_28955.png
5f3d3a986829393eafef0049_29421.png
0
0 votes

· Last Updated -

Comments

  • Martin Pecha_2338
    Martin Pecha_2338 Posts: 192
    100 Comments Second Anniversary 5 Likes Name Dropper
    edited February 24 #2

    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.

    image
  • Inês Batata
    Inês Batata Admin Posts: 3,155 COMMUNITY MANAGER
    2500 Comments Second Anniversary 5 Likes First Answer
    edited August 2020 #3

    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.

    image

    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!