ContributionsMost RecentMost LikesSolutionsRe: Checkbox Formula to Identify 3 Banking DaysYes, same record. This is how I have the fields on my form. And I am wanting the date of last strike versus the date of exception to be part of the formula. Date of exception would be a later date then the date of last strike is. ------------------------------ Dale Miller ------------------------------ Checkbox Formula to Identify 3 Banking DaysGood Morning, I am stuck on trying to create a formula where if two separate dates are within 5 calendar days within each other, that they would place a check in a checkbox. I assume it is a using checkbox-formula field. Better yet, is there a way to make Quickbase recognize 3 business days instead of just calendar days? For example; it does not include Saturday, Sundays, or Holidays. More of an example, Memorial day this year was Monday, May 25th, 2020. If the first date is May 21st, and the second date is May 27th, it would recognize that this is only 3 business days since we had the weekend + a holiday. If not, Just taking the 5 calendar days would be a huge help as described above. Any help on this would be greatly appreciated. :) ------------------------------ Dale Miller ------------------------------ Attempting to filter in Dynamic Rules Setting.Hello, I am in the Dynamic Rules setting, and I am trying to set it up where if I have the user supply the last date of an incident, that Quickbase will go back 6 months, and another rule for 12 months to see if we have another incident on file. For example, if I am doing an assessment today, and on my form I say the last incident was 3/15/2020, I want Quickbase to identify that the March date is within the past 6 months. If it is, then I want it to show something else on the form. If the user puts 1/15/2020 (which is over 6 months ago), for the quickbase to not show something else on the form. Hopefully I am explaining it correctly. I am also not sure what the + box is on the dynamic rule. Such as in the rule setting, "is on or before" "the current date" "+[ ]". What does the + box do? ------------------------------ Dale Miller ------------------------------