Hi all,
Please help me with this attribute, I am unable to achieve correct answer.
Tenure in Months
1- TIMESTAMPDIFF(SQL_TSI_MONTH,cast("Customer"."Customer Created Date" as date),cast(CURRENT_DATE as date))
Not giving correct answer.
Example:
Customer created date: 11-March-2021
Current date: 9-June-2021
Answer given by above sql: 3
The answer should be: 2
I have also tried other sql but unable to achieve correct answer, I cannot use Direct SQL method.
please help in this regard,
TIA