I am trying to put a formula to give a count of all orders whose ship date is until Jan 31. I am using CASE for this purpose. The best I can do is: CASE WHEN {shipdate} BETWEEN ({today}-365) AND ({today}+7) THEN 1 ELSE 0 END