0

Suggest include modulo function in documentation

Hi, I think it would be useful to document the modulo function (%). I couldn't see any mention of it in the Math function reference list. I find it very useful for filtering: for example in a database of my orchestra's library of works, I can get a list of composers whose anniversary (multiples of 50 or 100 years) it will be next year by creating a filter field containing the following:

if (year(now()) + 1 - year(Born)) % 50 = 0 or (year(now()) + 1 - year(Died)) % 50 = 0 then
   true
else
   false
end

John

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Mconneen
    • Mconneen
    • 3 yrs ago
    • Reported - view

    I agree.. the documentation is lacking!  Thanks for pointing this function out.. I can use it!

    Like
Like Follow
  • 3 yrs agoLast active
  • 1Replies
  • 1843Views