calculate months between two dates not working

Viewing 1 replies (of 1 total)
  • Plugin Author codepeople

    (@codepeople)

    9 years, 6 months ago

    Hi,

    The DATEDIFF is an operation available only in the developer version of the plugin. If you are using this version, the correct equation would be:

    DATEDIFF(fieldname1, fieldname2, ‘dd-mm-yyyy’, ‘m’)[‘months’]

    But, if you are not using this version of the plugin, an equivalent equation would be:

    CEIL(ABS((fieldname1-fieldname2)/30))

    Best regards.

Viewing 1 replies (of 1 total)
  • The topic ‘calculate months between two dates not working’ is closed to new replies.

Tags