1 of 1 people found this helpful
The calculation looks at the Month only and will take the difference (integer) between the 2 months - it is not going to give you partial months -
it uses datepart which returns and integer value for the month
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thanks for the answer. I think I will have to add AND condition considering day part.
I was going to suggest that - then you need to convert that to months - using something like a case statement to account for the different number of days in each month