I have 2 dates (in the form MM/DD/yyyy) representing the start date of the employee and the end date of the fiscal year:
the employee started working on 12/15/2010 and the fiscal year ends on 08/31/2011
I want to calculate the number of months that the employee worked between those 2 dates
in reality this employee will have been working until 08/31/2011 for 8.5 months
datediff function returns 8
how to calculate exact number of months in sql?
thank you in advance
View Complete Post