Age calculation

  • vijok

    (@vijok)


    1 year ago

    PD’s age calculation formula seems not to work for me. It is said to be:

    [#current_date]-[‘birthdate’]=[?years] (‘birthday’ = user defined variable)

    My formula is: [#current_date]-[syntym?aika]=[?years]

    I don’t get any result of calculation and the field referring to age stays empty. Form element is ‘Numeric Calculation’ as it should be.

    Any ideas, what goes wrong? Could the ‘a’ with dots cause trouble in a variable?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author xnau webdesign

    (@xnau)

    Accented characters are not a problem, this has beend tested.

    Is “syntym?aika” a date type field? Only a date field will work here.

    Also, the age field is only updated when the record is edited. Just setting up the age field isn’t enough, you have to trigger an update to the record so it will perform the calculation.

    Thread Starter vijok

    (@vijok)

    Hi,

    “Syntym?aika” was actually a plain text-field, but I changed it to a date -field and after updating the record the calculated age appeared as it should be.

    I’m just wondering, could it possible to calculate the age right away and save it when adding a new record for the first time?

    Plugin Author xnau webdesign

    (@xnau)

    Yes, if the field with the birth date is submitted with the new record, the age will be calculated and saved with the new record.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Age calculation’ is closed to new replies.

Tags