With Caspio’s Advanced Reporting feature, calculated fields you can find the difference of two dates and calculate for example the age of a person to year, month or day granularity.

The article about Calculated fields describes the function Datediff(year, [@field:DOB], GetUTCDate() to calculate age. To use this function to calculate at month and day granularity try:



More information about all the parameters and options of DateDiff is available at http://msdn.microsoft.com/en-us/library/ms189794.aspx.