Re: # of bill cycle

what have you tried?

"ML" <microlander_at_yahoo.com> wrote in message news:f344732f.0406081116.383ec141_at_posting.google.com...
| 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
Received on Sat Jun 12 2004 - 15:07:58 CEST