Confluence User •

08 Oct, 2023 •

confluenceUser •

•

confluenceUser •

It is not recommended at all but you can use a jQuery for that if it is really required. You won't be needing a Beanshell.

<script>
        $(document).ready(function () {
            // Date input change event handler
            $("#birthdate").on("change", function () {
                var birthdate = new Date($(this).val());
                var today = new Date();
                var age = today.getFullYear() - birthdate.getFullYear();

                // Check if birthday has occurred this year
                if (today.getMonth() < birthdate.getMonth() || (today.getMonth() === birthdate.getMonth() && today.getDate() < birthdate.getDate())) {
                    age--;
                }

                // Populate the "Age" field
                $("#age").val(age);
            });
        });
    </script>

Usually in a database you don't store values that you can calculate, it can cause issues. For example the Age will change as the current date (today date) changes and you wont be updating age field daily in all the records.
So I would suggest that you store the DOB and get the Age using that stored DOB.
You can display Age in the list by using the following SQL command.

SELECT DATE_FORMAT(FROM_DAYS(DATEDIFF(NOW(),"date_of_birth")), '%Y') + 0 AS age;

Confluence User •

08 Oct, 2023 •

confluenceUser •

•

confluenceUser •

Thank you for replying.

If I use the SQL method instead, do I just add the query to the Age text field?

Thank you very much for your help.

Confluence User •

09 Oct, 2023 •

confluenceUser •

•

confluenceUser •

SQL will be used on the datalist. You will use DOB column to get age and display in the front

1

CSV | Excel | XML | PDF