Nested conditions

Topic Labels: Dates & Timezones
369 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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?

1 Reply 1

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