AnsweredAssumed Answered

summing a field by a date

Question asked by mikedorn on Aug 1, 2011
Latest reply on Aug 10, 2011 by philmodjunk


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)?