Nested conditions

[rob_smith]

i have a table called MetonicAppFileK which a number of fields including today’s date, which ive called GregDate. One of the fields in the table shows the Metonic Year for each day called MetNo. i would like to select records based on the value of MetNo for today;'s date GregDate.
So i first need to find the MetNo for today’s date. then select all records with the same MetNo.
any idea how i would do this?

[TheTimeSavingCo]

Hi Rob, could you share some screenshots of your data as well as what records you’d like selected from the screenshot?

I think you might have to have a formula field that handles all the logic for you that you would then filter on, but can’t be certain about it without seeing your table