<@U4G32RNUV> `CASE WHEN {subscriptiondate} &lt;= '...
# suiteanalytics
k
@jcribb
CASE WHEN {subscriptiondate} <= '30/05/2018' AND {subscriptionstatus} = 'T' THEN {subscription} END