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.
Calculated Field on Query
-
- Posts: 303
- Joined: Wed Apr 22, 2015 11:44 pm
Re: Calculated Field on Query
Actually the error is "Incorrect Syntax near ')'."
Re: Calculated Field on Query
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.
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
Jaymer
Aware Programming & Consulting - Tampa FL
-
- Posts: 303
- Joined: Wed Apr 22, 2015 11:44 pm
Re: Calculated Field on Query
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.