# of bill cycle

i need to write an sql which calculates # of billing cycles for an order for which ive order start and end date. the first invoice will be cut on the order start date. Also if i apply a coupon for lets say one month (30 days) to that order i need to calculate how many billing cycles that coupon will apply to.
ive start and end date of coupon ina diff table for that order

for eg: if an order was started on 1/15 and ended on 4/14 i have 3 billing cycles (the invoice was suppose to cut on. 1/15 , 2/15 and 3/15)
lets say on 3/15 if a users applied one month coupon which means he didnt have to pay for billing cycle 3/15.

can someone help me with this logic

thank u
ml Received on Tue Jun 08 2004 - 21:16:41 CEST