I have 2 fields in a report that allows me to script fields with VB. The fields come from SQL which are calulated like this:
Years:
DATEDIFF(MONTH,EFFECTIVEDATE, ISNULL(ENDDATE,GETDATE())) / 12
Months:
DATEDIFF(MONTH,EFFECTIVEDATE,ISNULL(ENDDATE,GETDATE())) % 12
What I am getting in the...