1

Calculating an age at a certain time

I am trying to calculate the ages of students when they start a programme. 

I had this in a ms sql database as (floor(datediff(day,[DATEOFBIRTH],[LEARNSTARTDATE])/(365.25)))

How can I calculate this in NX?

Thanks

4 replies

null
    • Andrew.1
    • 6 yrs ago
    • Reported - view

    I may have answered my own question. I think it is 

    days('Date of Birth', 'Start Date') / 365.25

    • Sakshi_Singh
    • 6 yrs ago
    • Reported - view

    Hi Andrew,

    You can use,

    age(Birthdate) -> The current age of a person with given Birthdate in years.

    Link to function list, https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language

     

    Regards,

    Sakshi- Ninox

    • Andrew.1
    • 6 yrs ago
    • Reported - view

    Hi Sakshi,

    Thank you - I had seen that formula to give me the current age - what I needed was the age when they started their programme.

    The formula days('Date of Birth', 'Start Date') / 365.25 seems to be producing the result I needed.

    • KempNuclear
    • Scott_Kemp
    • 4 yrs ago
    • Reported - view

    Hi Andrew,

    My students are developing something similar to AgeCalc and then they will also need to create Calendar appointments for certain groups of school kids (we have a summer research club for schools at Technological Education Institute of Central Macedonia). Is it possible to use a custom Chronological Age Calculator with Ninox? Thanks.

     

    Ninox FAQs: Create weekly recurring appointments to evaluate every lesson I give to a student and buy essays

Login to reply

Content aside

  • 1 Likes
  • 4 yrs agoLast active
  • 4Replies
  • 2628Views