Calculated Field on Query

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
Jhstephenson
Posts: 297
Joined: Wed Apr 22, 2015 11:44 pm

Calculated Field on Query

Post by 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
Posts: 297
Joined: Wed Apr 22, 2015 11:44 pm

Re: Calculated Field on Query

Post by Jhstephenson »

Actually the error is "Incorrect Syntax near ')'."
Jaymer
Posts: 2430
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

Re: Calculated Field on Query

Post by 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.
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.

Jaymer
Aware Programming & Consulting - Tampa FL
Jhstephenson
Posts: 297
Joined: Wed Apr 22, 2015 11:44 pm

Re: Calculated Field on Query

Post by 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.
Post Reply