Participants Database
Determine participant age (2 posts)

  1. cristch_27
    Posted 2 years ago #

    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


  2. xnau webdesign
    Plugin Author

    Posted 2 years ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • Participants Database
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic


No tags yet.