If (Attendance::ClassIdFk = 1 and Attendance_Details::Status = "Present"; Attendance::Date = Date ; " ")
I am using it in my date calculation for a student tracking app. I want the date to be inserted if the Attendance::ClassIdFk=1 and the Attendance_Details::Status = "Present". If not leave date blank. It does not seem to work. Any advice? I tried this calculation on both the field calculation and the portal filter. Thanks!