Question

Modify the search expression for InvoiceDueDate from the previous solution. Rather than 30 days from today, return invoices due before the last day of the current month.

This is what I have and I referred to it in the title as "Previous solution":

SELECT InvoiceNumber, (InvoiceTotal - PaymentTotal - CreditTotal) AS Balance, InvoiceDueDate
FROM Invoices
WHERE (InvoiceTotal - PaymentTotal - CreditTotal) > 0 and InvoiceDueDate < GETDATE() + 30;

Answer 1

Please find my answer:

SELECT
InvoiceNumber,
(InvoiceTotal - PaymentTotal) as Balance
FROM Invoices
WHERE
InvoiceTotal - PaymentTotal > 0
AND
InvoiceDueDate BETWEEN DATEADD(DAY, -1, GETDATE()) AND GETDATE()

Please DONT forgot to rate my answer. We are working hard for you Guys!!