List Student’s Age
Select All your students and in the functions dropdown select Quick Export. Key in the following (you can probably copy & paste) and add/remove any fields you need.
lastfirst
grade_level
DOB
~(*evaluate trunc(~(f.div;~(f.sub;~(f.currentdate);~(dob));365.25),0))
Select CRLF in Record Delimiter, check for Column titles on 1st row and Submit. Save the file to your desktop.
Go to your desktop, right click on the file you just saved and open in Excel. This should give you the student’s age in years from today’s date.
| Lastfirst | Grade | Level | DOB | *evaluateTruncf.div |
| Anderson, Cody N | 9 | 3/8/1994 | 16 |