In order to avoid confusion with other queries, created the same.
Can we use the below in COUNT or DELTA or even IF ELSE?
Date 1 and Date 2 below are the formula variables with Ref char as their respective dates.
Month 1 and Month 2 are formula variables with ref char as their dates with offset (From 0 to 6), with currency/unit dimension as Date
Please check the below for ref and let me know if its correct.
COUNT ( Date 1 == Date 2), result is 1
DELTA (Date 1 <=> Date 2), result is 1
COUNT ( Month 1 == Month2), result is 1
These are being used in formulas to calculate count of orders which satisfy above conditions.