Start Building Professional
Web Apps Today

Best Way to Calculate Age - DHTMLXGRID

I am using the DHTMLX GRID, and am importing a CSV that, among other things, contains birthdates. I would like to populate a column with their current age, based on the current date. I have tried mayn different things, but just can't figure out how to do this.

Any help would be appreciated!

You can use code similar to next ( code suppouse that data stored in default mm/dd/yyyy format ) 

grid.attachEvent("onRowCreated",function(id){
       var date = grid.cells(id,INDEX).getValue(); //get date
       var years = (new Date()).getYear()-(Date.parse(date)).getYear();
       grid.cells(id,INDEX).setValue(years); //set years
       return true;
});

INDEX - index of column in question

I have tries this, and can't get it to work.  I get Object does not exist errors.

Please check attached sample. 

Thanks!  Now I see what I was doing wrong.  I have to say... I am VERY IMPRESSED with the speed and quality of support!