jcribb
NS_CONCAT(CASE WHEN {subscriptiondate} <= '30/05/2018' AND {subscriptionstatus} = 'T' THEN {subscription} END)