See records from the same month

I'm having difficulty searching the sqlite3 database, records for a specific month, I searched the internet but found nothing that could help me. I have an account template that has belongs_to with the class Location that is an enum where it has pending or paid status. I would like to search the bank, accounts that are of a specific month and are paid but still can not filter. Any suggestion? Thanks in advance.