If you have questions or if you want to share your opinion about Aware IM post your message on this forum
#54500 by Jhstephenson
Mon Aug 10, 2020 4:42 pm
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.
#54502 by Jaymer
Mon Aug 10, 2020 6:31 pm
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.
#54511 by Jhstephenson
Fri Aug 14, 2020 4:48 pm
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.

Who is online

Users browsing this forum: Google [Bot] and 51 guests