Working with Fiscal Year dates and counting attendance

Help Center Get Answers
1

Hello! Knack Newbie here. Coming over from Airtable with hobbyist-level DB experience.

Our Org runs on a Fiscal Year, July thru May, not calendar year. We track meeting attendance and each of our members are required to get a minimum of 6 Meeting Credits during our “year.” If they have < 6 they go on probation.

In airtable we accomplished this by creating a Fiscal Year table, defining the Start and End date of each year (past and 10 years into the future), and coding a “Current Year Flag.”

IF(
  AND(
    DATESTR(NOW())>={Start Date},
  DATESTR(NOW())<={End Date}
  ),
  "Current Year",
   IF((YEAR({End Date}))=((YEAR(NOW()))-1), "Last Year"))

image

Then, as we record Attendance, we LOOKUP the Meeting Date and set the Current Year Flag if the date falls within the current fiscal year.

image

To view a Member’s Current Meeting Count, we’d pull the Attendance Record and filter by “Current Year”

image

I’m struggling to replicate this functionality in our new Knack DB. Any ideas?
Thx in advance!

2

See if this video by Carl Holmes helps you.

3

This is the link to a previous post. Not sure it will help but may provide some additional inspiration.