Question

BlueRose Technologies
IN
Last activity: 17 Mar 2017 12:02 EDT
How to calculate Age from Date of Birth via Function Alias rule
Hi All,
I want to calculate Age from Date of Birth via Function Alias rule where I can fetch the Date of Birth from a table which is in the format '9/20/1946 12:00 AM' so that I can show it as a column in a Report Definition.
I have tried some SQL Server code but is throwing an exception on running the Report Definition.
I have been suggested to make use of the function alias 'pxDifferenceInHours' but not sure how. PFA doc for the design screenshots.
Can somebody help me on this?
Thanks in advance.