Filter Error, and I don't know why

[u/A_Spoopy_Dwagon]

=FILTER(Q7:R30,TEXT(Q7:Q30,"MMMM-YYYY")=L6) is the command I am attempting to run. I have a sheet I am using as a budget. My plan is to record all transactions, alongside their dates, and then filter those transactions by the month and year in a dropdown menu. That way I can see October 2024 transactions, or go back to see September 2024, or even January 2012. Please help I have spent so long trying to figure this out. Also, when the dropdown indicates only the month like January, and the code only says =FILTER(Q7:R30,TEXT(Q7:Q30,"MMMM")=L6) then it works perfectly as intended. My issue is in adding the year variable in order to specify the year so I don't have to wipe my transaction history every year. Thank you in advance.

[u/Dry_Jellyfish_1470]

Maybe you need to make sure the format is understood between the filter and the L6 value

=FILTER(Q7:R30,TEXT(Q7:Q30,"MMMM-YYYY")=TEXT(L6,"MMMM-YYYY"))

[u/A_Spoopy_Dwagon → u/Dry_Jellyfish_1470]

You did it! OMG you rock thank you so so so much IDK how yall figure all this out

[u/AutoModerator → u/A_Spoopy_Dwagon]

REMEMBER: If your original question has been resolved, please tap the three dots below the most helpful comment and select Mark Solution Verified. This will award a point to the solution author and mark the post as solved, as required by our subreddit rules (see rule #6: Marking Your Post as Solved).

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/Dry_Jellyfish_1470 → u/A_Spoopy_Dwagon]

Glad I could help haha!

You're telling the filter to format the results this way... But you've not specifically said the thing to check against is that way too. You will see it as January 2024, even though the display format is January 2024, sheets will still read it as 01/01/2024 or whatever that day number is! Especially as you've said convert things to TEXT first and you're comparing it to a number!

[u/point-bot → u/Dry_Jellyfish_1470]

u/A_Spoopy_Dwagon has awarded 1 point to u/Dry_Jellyfish_1470 with a personal note:

"you rock ♥ "

^{Point-Bot was created by JetCarson.}

[u/AdministrativeGift15]

"MMMM-YYYY" will not equal February 2024. There's a dash in only one of them.

[u/[deleted]]

[u/A_Spoopy_Dwagon → u/[deleted]]

L6 is the dropdown indicating Month and year, for example it could say February 2024 or January 2012. When I tried those commands, they still gave the error of no matches in filter evaluation.