I am putting together a membership database for a nonprofit charity in LibreOffice, but have no experience in mysql queries so I would appreciate the help.
I am trying to create a query that displays all records where the membership signup date field (PaymentDate) is older than 1 year of the current date AND a boolean value of another field (AwaitingRenewal) is NO. The date is in 05/03/85 format. Thanks for any help you can give me!
You can do something like:
select * from `members`
where `paymentDate` < DATE_SUB(CURDATE(), INTERVAL 1 YEAR)
and `AwaitingRenewal` = 'NO'
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With