Hi Brandie,

Thank you so much for that. Really appreciate your help 🙂

Kind Regards,

R

Hi Brandie,

Due date is DATETIME and i am literally just looking for 2 months data.

Kind Regards,

R

Hi,

The code is

SELECT h.apar_name,a.ext_inv_ref,a.currency,SUM(a.rest_amount) AS Outstanding,a.account,a.trans_date, a.due_date,a.rem_level,a.remind_date, a.voucher_no, a.apar_id, h.apar_gr_id,DATEDIFF(MONTH,a.trans_date,a.due_date) AS MONTHS, a.status, a.pay_flag, a.dc_flag

FROM acutrans a

INNER JOIN acuheader h ON a.apar_id=h.apar_id AND a.client=h.client

WHERE DATEDIFF(MONTH,a.trans_date,a.due_date) >=...

Hi,

The due date is coming from the database. So the report needs to run based on the day the report is run. For example if I run the report today...