How to show the sub count of selected count

[venkatbza]

Hi Friends,

I Have a date column, in that i have selected few dates randomly. now i want to show the count of dates which is less then today of current selections selections.

I have tried Getselectedcount but it is giving count of current selections, but i want only count less then today of current selections. 

For example as per the below screen shot i have selected few dates in that i want to show the count less then today.

and count should be shown into the text box.

let say today is 04/20/2020. then my count would be 5. 

please advise how to achieve this. 

Thanks,

Venkat

[Frank_Hartmann · Accepted solution]

=count({<tmpdate={"=tmpdate<=Today()"}>}tmpdate)

[lironbaram · Accepted solution]

Hi 

this should work for you 

=count(DISTINCT if(date<date(today(1)),date))