View original (French)

Age calculation based on dates

Solved
MaiBZH Posted messages 1 Status Member -  
m@rina Posted messages 27633 Registration date   Status Moderator Last intervention   -

Hello,

I am a healthcare professional, and part of my job involves writing assessment reports. I would like to automate certain tasks, such as the automatic calculation of my patients' ages based on:
- The date the assessment was conducted (and not the date of writing);
- Their date of birth;

I am not sure if this is feasible in Word,

Thank you for your help, M.


2 answers

  1.
    brucine Posted messages 24984 Registration date   Status Member Last intervention   4 181
     

    Hello,

    It's much easier in Excel or by incorporating a suitable Excel table into Word.

    Regarding Word itself and the date of birth, the answer seems to be provided here by Anacoluthe.

    For creating a report and if it's about knowing how old it was done, I suppose the process is the same but this time by subtracting the date of birth from the date of the report.

    https://www.generation-nt.com/reponses/calculer-un-age-entraide-198757.html

    1
    1. m@rina Posted messages 27633 Registration date   Status Moderator Last intervention   11 564
       

      Hello

      The thing from 20 years ago!

      Back then, anacoluthon and I (the famous webmistress Circe :)))) were young and complex fields were still very complex! So the anacoluthon formula is wrong.

      And since Microsoft hasn't improved things, for those interested, I'm providing the solution here (in the famous faq.ms.word.free.fr which has since become faqcord.com!)

      http://faqword.com/index.php/word/publipostage/comment-dans-un-publipostage-ajouter-un-mois-ou-un-an-a-une-date

      That being said, if one really wants to use Word, one can easily go through a macro.

      m@rina (Circe)

      0
  2. Agito
     

    To automate the calculation of your patients' ages based on the date of the assessment and their date of birth, here is an example of a Python script that you can use:

    ```python
    from datetime import datetime

    def calculate_age(birth_date, assessment_date):
        birth_date = datetime.strptime(birth_date, "%Y-%m-%d")
        assessment_date = datetime.strptime(assessment_date, "%Y-%m-%d")
        
        age = assessment_date.year - birth_date.year - ((assessment_date.month, assessment_date.day) < (birth_date.month, birth_date.day))
        return age

    # Example of use
    birth_date = "1990-05-15"
    assessment_date = "2024-07-31"

    age = calculate_age(birth_date, assessment_date)
    print(f"The patient's age is {age} years old.")
    ```

    You can adapt this script according to your workflow. Here are some additional explanations:

    1. **Importing the datetime module**: The `datetime` module is used to manipulate dates.
    2. **Function `calculate_age`**: This function takes two arguments, `birth_date` and `assessment_date`, and returns the age in years.
    3. **Converting strings to datetime objects**: The birth and assessment dates are converted to `datetime` objects to facilitate calculations.
    4. **Calculating age**: The age is calculated by subtracting the birth year from the assessment year and adjusting based on months and days.

    You can integrate this function into an Excel file, a patient record management software, or any other tool you use to manage your assessments.

    If you need help integrating it into a specific environment or adapting the script, feel free to let me know!

    0