Count within Date interval

juraj_pavol — Thu, 07 Jun 2018 13:35:58 GMT

Hi all,

I try to solve following problem but with no success.

I have data in following structure

On the sheet I have Data picker where I can select date in format eg. 04/2018 = Select month

1. I need count all records where Activation date <=Select month <= Expiration date

I try this but it not works:

Count(distinct{$<[Select month]={">=[Activation date]<=[Expiration date]"}>}[Item name])

2. I need count all records where Activation date <=Select month <= Expiration date

and also if Expiration date is NULL it will be counted to total count

Please could you help me.

Thanks in advance.

topic Count within Date interval in App Development