Improvements to advanced list filter conditions

While attempting to create a list that will identify the students in the building that are having a birthday today I wanted to build the list such that the filters did not need to be continually updated on a daily basis.  So I tried to use the filter condition "on" with the "relative" operator on the User Detail.Dob field.  The default unit is "days ago" so for a 12 year old student the value would need to be set to 4380, seemed simple enough but the value field is limited to 2 digits.  So I looked at the different units available, but necessary units would be "years ago" properly filter the list while still keeping the 2 digit  value limitation.  So it ended up being a nice little filter feature with an unfortunate limitation.

In summary, it would be really great to either expand the value limitation to 4 digits or add the "years ago" unit as either one would be effective.

  • Gregg
  • Sep 13 2016
  • Attach files