I’m putting a report together for our accounting department that shows current agents draw amounts, balances, start dates, terms and such. So far so good.
I am stuck on coming up with a way to have a custom column that will update a due date field automatically. The dataset given to me does not have a due date currently, only start date and terms in months.
Start Date (date field) + Terms in Months (numeric field) = Due Date
I am thinking this may be the job for DATEADD, but not sure how to make it happen.
Any tips would be much appreciated.