Calculated Field on Query

Jhstephenson

Is there an issue using the AGE function to create a calculated field on a Query?

I have a form where I display an Age based on AGE(Participant.DateOfBirth) in an HTML row and it works great.

If I try and add a Calculated Column to a query though I get an "Interal Error at ')'" message and the calculation is the exact same thing as on the form.

Jhstephenson

Actually the error is "Incorrect Syntax near ')'."

Jaymer

calc cols on a grid are Stinkers.
can't sort or filter.
i think there has been an improvement to the builder/editor portion (used to be VERY hard to use), but what seemed like what would have been a great feature has not really been that useful for me.

Jhstephenson

I found that YEAR_DIFFERENCE(CURRENT_DATE, Participant.DateOfBirth)gives the same result, or at least close enough, and actually works in a calculated field.