Home I have this line of syntax that I need to replace the static date so that it just calculates on the Transaction Date
 SUM(CASE WHEN DATEDIFF(d , TransactionDate , '2018/05/09') BETWEEN 100 AND 600 THEN (TotalValue-TotalPaidtoDate) end )AS [30DaysAmount]