Determine participant age

  • Any chance of determining the age of the participant through birth date obtained in the registration form?.

    Currently I use an Stored Procedure in mysql for calculating age every day is updated through all the records in the database, and the result I add in a field that you create but do not show it in the registry, but drawbacks since the date field is in unix timestamp format and dates before 01-01-1970 I generated null fields.

    Is there any way to perform this calculation in the template where participants sample or any specific class.

    Thanks for your help

    https://www.ads-software.com/plugins/participants-database/

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

    (@xnau)

    Well there are several ways to approach this. If you want to just show a person’s age based on their date of birth, you need to create a custom template that performs that calculation and shows the result.

    UNIX timestamps for dates before “zero” are represented with negative integers. You just need to make sure your procedure can work with signed integers.

Viewing 1 replies (of 1 total)
  • The topic ‘Determine participant age’ is closed to new replies.