hmmm. just a general notice: A customer loyalty program, which expires earned points, not to let the customer "win" anything valuable? If I were your client, I wouldn't be happy with this.
2007/3/18, Naz Gassiep <[EMAIL PROTECTED]>:
We are running a customer loyalty program whereby customers earn points for purchasing products. Each product has a value of points that are earned by purchasing it, and a value of points required to redeem it. In order to prevent customers from stockpiling points, we want to place an expiry date on points so that unused points expire and are lost if they are not redeemed within a certain period of time. This will be calculated on a FIFO basis, I.e., the oldest points will expire first. We will assume the expiry period is 12 months.
-- Filip Rembiałkowski ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings