Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=count({<tmpdate={"=tmpdate<=Today()"}>}tmpdate)
Hi
this should work for you
=count(DISTINCT if(date<date(today(1)),date))
=count({<tmpdate={"=tmpdate<=Today()"}>}tmpdate)
Hi
this should work for you
=count(DISTINCT if(date<date(today(1)),date))