I have to calculated fields:
,[Contract_NetStartDate] = CASE WHEN ContractStartDate <= @ReportStartDate THEN @ReportStartDate ELSE ContractStartDate END
,[Contract_NetEndDate] = CASE WHEN ContractEndDate >= @ReportEndDate THEN @ReportEndDate ELSE ContractEndDate END
I need to add a third calculated field:
The third field is the number of months between [Contract_NetStartDate] and [Contract_NetEndDate]
Is it possible that some one show me how to obtain that number from the two fields?
Thank you much.