Suggest include modulo function in documentation
J

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

Ninox Profile

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

Reply