I am trying to create a procedure that shows the time difference between 2 dates. I can do this using datediff or dateadd functions, but I need to band the output in calendar months.

Examples below:

Date1 = 29th February 2004
Date2 = 30th January 2004

Date 2 would need to appear in the 2nd month banding, but by using dateadd I get this in the 1st month banding.

Does anyone know how to do this?