OTBI: Diff of Two dates to get Age is rounded to next highest value
Summary
OTBI: Diff of Two dates to get Age is rounded to next highest valueContent
OTBI: Diff of Two dates to get Age is rounded to next highest value
Example: If difference of Age is 48.8 Its displayed as 49 instead of 48 even after using FLOOR or TRUNCATE.
Below is the formula I used still unable to succeed.
FLOOR(TimeStampDiff(SQL_TSI_YEAR, "Dependent Data"."Dependent Date Of Birth", Current_Date))
Your help is highly appreciated.
1