Customer SELECT with payment for the last two months (60 days)

Question

Customer SELECT with payment for the last two months (60 days)

Asked 3 years, 10 months ago

Viewed 51 times

1

I have a TBCLIENTS table where I have the columns: NAME, DATA_PAGAMENTO, FORMA_PAGAMENTO. I need to know the customers who paid in the last 2 months (60 days) in the form of payment BOLETO. How I can perform this SELECT on the date to pull the last 2 months, with this condition: through Lottery with mail form.

1

Does that answer your question? https://answall.com/questions/332929/retorno-3-meses-anteriores-desdo-dia-1

– Dakota

2021/02/05 at 18:15
Yes, thank you Maria Eduarda. .

– Lucas Lira

2021/02/05 at 18:16
Just define more precisely the period to be considered. Considering today’s date (06/02/2021) with "last 2 months" you want after 07/12/2020 or between 01/12/2020 and 31/01/2021? With "60 days" would be 08/12/2020 onwards?

– anonimo

2021/02/06 at 13:58
Good morning, that’s actually how it is. The customer he owns invoices and I need his 2 invoices in the last 2 months that were paid in lottery with mail form.

– Lucas Lira

2021/02/08 at 12:13

No answers

Browser other questions tagged sql query tsql

You are not signed in. Login or sign up in order to post.