3 Replies Latest reply: May 15, 2014 9:57 AM by DZizzo _ RSS

    Age function

    DZizzo _

      Can someone tell me what the correct syntax for the enddate in the Age function is?  If I say:

       

      AGE(Birthdate,Today(),2) everything is fine. (Birthdate is the field in my file).

       

      If I say:

       

      AGE(Birthday,9/10/2007,2) I keep getting the "Operand Types" error message.

       

      Any ideas?  I'm using Monarch Pro V9.  Thanks!