Does any one know of a way to count the number of months between two time periods. I am trying to develop a count down methodology for a time period over 5 years and I want the periods to shrink every month. Any help would be greatly appreciated
12 * Year ( EndDate ) + Month ( EndDate ) - 12 * Year ( StartDate ) - Month ( StartDate ) - ( Day ( EndDate ) < Day ( StartDate ) )
Note that this assumes a month elapses on the same day-in-month as StartDate or when the month ends - whichever happens first.
Thank you Michael
If you go to http://www.briandunning.com and search for my custom functions, I have several that might be useful along this line.
Ron Smith, MD
Retrieving data ...