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?
Nested conditions
+31Hi 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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.