I am trying to design a rental system with automatic invoicing based on the date such that:

if the rental start date is in the current month and the start date is not the 1st of the month then

Rental/Number of days in the month*(number of days in the month-Rental start date)+commision.

And conversely if the rental end date is in the current month etc.

Can anyone help construct this formula please

Chris

Case (Month(rentalStartDate)=Month(Status(CurrentDate)and Day(rentalStartDate) > 1 ; (rentalAmount/numberDaysinMonth)*(Date(Month(Status(CurrentDate)))+1,0,Year(Status(CurrentDate)))-rentalStartDate)+commission

The other calculations would be similar. In version 7, using Let, we could simplify the calculation drastically.

Thank you for your help, I have today received my FMP7 (V7.02) and installed it, how would Let be simpler. By the way FMP7 appears much slower launching a solution than either 5.5 or 6. Is this because these solutions were designed in previous versions and then converted.

Chris

I can not get this expression to work, numberDaysinMonth, I have tried different syntax but to no avail

Chris

It's hard to know what the last day of the month is. But it's easy to know what the first day of next month is, then substract 1:

Day ( Date ( Month ( Get (CurrentDate) ) + 1; 1; Year ( Get (CurrentDate)) ) - 1 )

Actually, there is a special, rather odd way to get the last day of the month. It's day 0 of next month. So this also works:

Day ( Date ( Month ( Get (CurrentDate) ) + 1 ; 0; Year ( Get (CurrentDate)) ) )

Fenton:

Nicely done. It's always good to see some code that gets the cereal into the bowl in just the right (non-rectilinear) way.

-Stanley

Wow, now I know why I feel dumb, it's because I am. Thanks for all your help

Chris