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?