For more information, please refer to this announcement explaining best practices for getting answers to questions.
Time Stamp Diff based on User Entered Date Value
Summary:
Time Stamp Difference function calculating with user prompted date value
Content (required):
I am using the following function to calculate years of service. I'm attempting to calculate this as of a date value that the user would enter.
Currently, I can successfully calculate years of service using CURRENT_DATE. Is there a way for the third variable in this function to be a date the user enters?
TIMESTAMPDIFF( SQL_TSI_DAY , Work Relationship Start Date, CURRENT_DATE )
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
TIMESTAMPDIFF( SQL_TSI_DAY , Work Relationship Start Date, CURRENT_DATE )