Calculate Age for a Student

[James_Robertson]

I want to add a read only calculated field that gives me the age of a student in years. The value should be dynamic in the sense that it should be calculated at display and not really stored in the database. Any guidance on what field type to use? Also, is there a TODAY() type function that can be used as well?

[max_morais_dmm]

@James_Robertson use the “Read Only” fieldtype! it’s not stored in database, and you can customize they value using javascript

[ManasSolanki]

In addition to @max_morais_dmm’s answer, you can use Moment.js library for calculating the age of the Student or can refer the datetime.js file in the frappe.

[James_Robertson]

Thanks @max_morais_dmm and @ManasSolanki. That makes sense. So I am not a programmer type and don’t know javascript. Assuming I can figure that out, where on the doctype form do I place said code to have the field get calculated?

I essentially want to take the out of box date_of_birth field and divide it by 365.25 to give me the age in years as a whole number/integer.

Thoughts?

[MCD-50]

The date_of_birth field is of type ‘date’.
You can use:
var now = moment();
var total_days = moment(now).diff(date, “days”);
var number_of_years = Math.floor((total_days).toFixed(2) / 365.25);

[iMoshi]

Please help me calculate “age” of just about anything that’s given in a “date” field please please

[ROHAN_JAIN1]

@iMoshi

cur_frm.set_value(AgeField, moment().diff(cur_frm.doc.DATEFIELDNAME, 'years'));
cur_frm.refresh_field(AgeField)

[iMoshi]

@ROHAN_JAIN1

cur_frm.set_value(AgeField, moment().diff(cur_frm.doc.DATEFIELDNAME, ‘years’)); cur_frm.refresh_field(AgeField)

OMG, thank you so much! Just had to add semicolons and apostrophes you are a life saver!

However, this code is not working on child tables. Any help on that…?

Thank you again!

[ROHAN_JAIN1]

@iMoshi

@iMoshi

this code is not working on child tables. Any help on that…?

For child Table,
cur_frm.doc.CHILDTABLE_FIELD_NAME[index].AGEFIELD=moment().diff(cur_frm.doc.DATEFIELDNAME, ‘years’)
cur_frm.refresh_fields(“CHILDTABLE_FIELD_NAME”)

[suraj.jahagirdar]

You can create your custom fields(i.e read only and other fields) using customize form , have to write custom script to calculate the age (@ROHAN_JAIN1)has given . Export custom fields and custom script to app using fixtures. If you update doctypes your custom changes will be earsed , by using fixtures you can pull from repository to reflect your changes in your current system

[iMoshi]

Man, just can’t get it to work… Is hitting “Add script for Child Table” the right thing?

I have “birthday” date field and would like to have “Age” (child_age) read-only field to calculate Please take a look at the screen shot

Thank you so much!

[iMoshi]

Man, “I’m all in” deep. Got the dev mode on, did lots of changes to many DocTypes… Can’t go back

I’ve learned to not mess with the standard DocTypes, but we have really specific differences in my country.

[ROHAN_JAIN1]

Can you please share screenshot of child doctype too?

[suraj.jahagirdar]

[iMoshi]

Here you go

[ROHAN_JAIN1]

@iMoshi
frappe.ui.form.on(“Employee Children”, {
birthday:function (frm,cdt,cdn) {
locals[cdt][cdn].age=moment().diff(locals[cdt][cdn].birthday(), ‘years’);
cur_frm.refresh_fields(“ChildTableName”)
}
});

[iMoshi]

I somehow can’t get it to work. Fiddled with it a lot, no go ERPNext throws bunch of JS error no matter what I do… I’m just going to hide it for now.

Thank you so much Rohan!

[iMoshi]

I came across another question.

Can we calculate “duration” of a “start date” and “end date” in a child table?

Any help is appreciated.

Thanks guys!

[ROHAN_JAIN1]

Yes we Can calculate it.

Sum two Time fields

@Mahmoud_Ghoneem var duration = cur_frm.doc.duration; var postingTime = cur_frm.doc.posting_time; var hour=0; var minute=0; var second=0; var splitDuration= duration.split(':'); var splitPostingTime= posting_time.split(':'); hour = parseInt(splitDuration[0])+parseInt(splitPostingTime[0]); minute = parseInt(splitDuration[1])+parseInt(splitPostingTime[1]); hour = hour + minute/60; minute = minute%60; second = parseInt(splitDuration[2])+parseInt(splitPostingTi…

[iMoshi]

I should start paying you

Thank you again Rohan!