Drewru

Looks like I was on the right track, generally, but missing all of the edge cases. Thank you very much for straightening me out Raybaudi, you've been a big help.

Ok, one last question, I think (I hope). If I have a date range from June 15 to August 5, that should work out to 1 whole month plus 20 days. Doesn't the calculation I wrote get me that? I was adding up the days from start to the start of the first whole month and the days from the end of the last whole month to end. I'm not sure what your clause is doing for me: ~days = If ( start - Day ( start ) = end - Day ( end ) and ~months ≤ 0 ; end - start + 1 ; ~start - start + end - ~end )

Ah. So, if I'm already pre-verifying that start and end are populated with valid dates, and that start precedes end, then I don't need the case statement?

Raybaudi, I get everything up to the case statement, it is essentially what I already had, but with correction for different years. I'm not sure I get what you're doing in the case statement.

Sorry, I didn't realize that I was being terse; I apologize if I was coming across as condescending or insulting. Yes, I have looked at the custom functions at Brian Dunning's site, and a couple of others but did not find what I wanted. To clarify, if I have 2 dates defining some period, I want the number of whole months plus the number of non-whole month days. A whole month being defined as day one of a month through the last day of that month. So, the 15th of one month to the 15th of the next month would not be any whole months. If the first day of the first month in the given range is not the first of that month, then that first month is not a whole month. If the last day of the last monthe in the given range is not the last of that month, then it is not a whole month. For example, If date1 is Jan 5, 2013 and date2 is Apr 2, 2013, then that would be 2 whole months plus 28 days (Jan 31 - Jan 5 + Apr 2 - Apr 0) Trying to clarify this and be explicit has led me to coming up with a possible solution. I think the following will get me what I need, did I miss something? Let ( [ // if Invoice Start is the first day of the month, use that; else use first day of the next month ~start = Contacts::Invoice Start ; ~start = If ( Day ( ~start ) = 1 ; ~start ; Date ( Month ( ~start ) + 1 ; 1 ; Year ( ~start ) ) ) ; // if Invoice End is the last day of the month, use that; else use last day of previous month ~end = Contacts::Invoice End ; ~end = If ( Day ( Date ( Month ( ~end ) + 1 ; 0 ; Year ( ~end ) ) ) = Day ( ~end ) ; ~end ; Date ( Month ( ~end ) ; 0 ; Year ( ~end ) ) ) ; // number of whole months ~months = Month ( ~end ) - Month ( ~start ) ; // number of non-whole month days ~days = ( ~start - Contacts::Invoice Start ) + ( Contacts::Invoice End - ~end ) ] ; ( Summary Total Weight * ~months * Invoice Rate ) + ( Summary Total Weight * ~days * Invoice Daily Rate ) + Summary Total Shipping - Summary Total Discount )

No, Feb 3 to Mar 3 is not a whole month, nor is Feb 3 to Feb 28. As I stated in my original post, a whole month would be defined as the first day of a month through the last day of that month. Please look at the examples I provided in my original post.

I'm trying to write a script (using FMP 11) that will compute the number of whole months (and days) elapsed between 2 dates, where a whole month is defined as the period from the first day of that month through the last day of that month. So: Jan 1 to Jan 31 = 1 whole month Jan 1 to Feb 1 = 1 whole month + 1 day Jan 15 to Feb 15 = 0 whole months + 30 days Jan 15 to Feb 25 = 0 whole months + 40 days.

mr_vodka, thank you. LaRetta, yes, that's exactly what I meant.

mr_vodka, could you please post a version of VisibleButtons.zip in the fp7 file format, for those of us who don't have/aren't allowed to buy, FM12?