Could not get row without date using Datapicker selector

1

Hello everyone :slight_smile: …I usually filter rows in table using multiple selectors chainded together; you can see a simplified example in the embedded doc. As you can see in the doc rows without date don’t show up whichever datapicker setting I use, even with “Everything”. I tried several variations like the following:
If(
thisRow.Date.IsBlank(),
“” ,
thisRow.Date.Matches(Datepicker)
)

…wihtout any succes! Could someone put me on the right path?
Thank you!

2

Dear @harlock,

Great that you made a sample to find more easy the right support :+1:

Would you mind to update the sharing settings as displayed in the pic below:

image

3

Hello Jean Pierre…that’s strange…could not find that sharing option:

Screenshot 2020-07-06 at 15.21.43
Screenshot 2020-07-06 at 15.21.431378×1740 185 KB

4

…ok found it and changed as you suggested :slight_smile:

5

Dear @harlock,

Please check out this version
In this way you will limit the available date you can select from3333

6

Thank you Jean Pierre for your working solution; so you do confirm that there isn’t any way to do the same using the datepicker selector? that’s a pity because you can’t access the datapicker features such as date range and so on…

7

…after several attempts I found a formula that is working and showing also empty date fields…don’t ask me how, I don’t know :slight_smile:
I’ve updated my first embedded doc with a working table.

Looks like this work:
If(thisRow.Date.IsBlank(),
1,
1 and thisRow.Date.Matches(Datepicker))

but my previous method that works well with text field search didn’t:
If(thisRow.Date.IsBlank(),
“”,
thisRow.Date.Matches(Datepicker))

Really don’t know why putting any number in the second and third position of the if block did the trick!

Hope this helps.