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.
Does that answer your question? https://answall.com/questions/332929/retorno-3-meses-anteriores-desdo-dia-1
– Dakota
Yes, thank you Maria Eduarda. .
– Lucas Lira
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
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