summing a field by a date
The "Attendance" table tracks employee tardiness. I need to count the number of times this happpens before a specific date.
Is this possible?
My tracking field is "Tardy_Count = (Global Date::g_Filter_Year = Record_Year; If( Code = "t"; 1 ; 0 )). How do I make this formula perform the same way using a cut-off date from an employee review form (another table)?