calculate difference between two dates

  • Resolved kjou06

    (@kjou06)


    1 year, 4 months ago

    Hello, Is there a mathematical formula to calculate the number of years between two dates or do I have to create a function?
    My request concerns the calculation of the age of a person starting from a current date field and a date of birth field

    Best regards

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

    (@codepeople2)

    1 year, 4 months ago

    Hello @kjou06

    Thank you so much for using our plugin.

    The plugin includes a module specific for Date/Time operations ( https://cff.dwbooster.com/documentation#datetime-module )

    For example, assuming the fieldname1 is the a date field to allow the users enter their birth date. You can insert a calculated field in the form and enter the equations:

    DATEDIFF(fieldname1, TODAY(), 'dd/mm/yyyy', 'y')['years']

    And that’s all.

    Best regards.

Viewing 1 replies (of 1 total)

The topic ‘calculate difference between two dates’ is closed to new replies.