# of bill cycle

[ML]

hello

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

[Mark C. Stock]

what have you tried?

"ML" <mi*********@yahoo.com> wrote in message
news:f3**************************@posting.google.c om...
| hello
|
| 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