Count rows in range of dates

[Inna_Shnaiderman]

Hi,

I have the following issue.

I need to count IDs in range of dates .

First  date should be start of fiscal month. Fiscal month is 21st day of the previous month. Meaning if now is January, start of fiscal month is 21/12/2020. The second date should be yesterday.

So it should be something like (count distinct  IDs where  date>=21st of the previous month and date<=today()-1). Can you please kindly help me on it? 

Thanks,

Inna

[AdiPai]

Hi , 

Try This

COUNT(DISTINCT{<Date = {">$(=Date(MonthStart(Today(),-1)+20,'DD/MM/YYYY'))"}>}ID)

Thanks

Adi

[Inna_Shnaiderman]

Hi, can you please assist where is the part it is till yesterday ? 

[Inna_Shnaiderman · Accepted solution]

Hi, I found an answer  , for the period till y-day it should be:

COUNT(DISTINCT{<Date= {">$(=Date(MonthStart(Today(),-1)+20,'MM/DD/YYYY'))"},

Date = {"<$(=Date((Today()-1),'MM/DD/YYYY'))"}>}ID)