Question

7
Replies
7748
Views
Giridhar_Metikal Member since 2014 95 posts
Instellars Global Consulting
Posted: January 18, 2017
Last activity: March 17, 2017
Closed
Solved

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.

Reporting
Moderation Team has archived post
Share this page LinkedIn