I have a pervasive database where the dates are stored in string like this 20101215
Dec 15 2012 = 20101215 which is my invoice date
I want to create a formula in crystal that will do this
If invoice date is between X and Y, then expiration date is Z
Z value is a hard coded date.
The formula is to create coupon on POS receipt