Difference between two dates with decimal output
Summary:
In an OTBI report, the requirement is to calculate years of service for terminated employees (difference between hire and term dates). The output needs to be 2 decimals, for example 2.07 or .06. Maybe I'm using the wrong formula. Thanks for your help!
TIMESTAMPDIFF(SQL_TSI_MONTH, "Worker"."Enterprise Hire Date", "Worker"."Termination Date")
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):