Skip to main content

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?

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

Reply


Terms & Conditions