I have to construct a query that shows the expected payment date if invoices are due within 30 days of a transaction.
I think its +30 to the invoice date and I'm going to show this as a new column called "Payment_Due Date" I'm stuck on this syntax.
select ...
,dateadd(dd,30,invoice_date) as payment_due_date
from ...
where invoice_date>=dateadd(dd,-30,getdate())
1 Like
Thanks bitsmed