I have three fields of date, one field is date create, date approval and effective date (when is not approve we considering today day)
EFFECTIVE DATE = IF (BLANK (DATE APPROVAL), TODAY(), DATE APPROVAL)
We create a column with diferrence date in days:
DIF = DATEDIFF(DATE CREATE, EFFECTIVE DATE, DAY)
We want analyse average DIF for example, year 2021 (01.01.2021 to 03.31.2021) but we have a problem beacuse the records thath do not have approval don´t appear in the analysis, beacause effective date is Today.
How can we analyse the measure by moth considerin the accumlates up today´s date?