Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
formula :aged 91-120 days 1
- Thread starter farrelm2
- Start date
Try this:
If {YourDateField} in Dateadd("d",-91,CurrentDate) to {Dateadd("d",-120,CurrentDate) then {YourAmountField} else 0
Write a similar formula for over 120 days.
let me know if you have any questions. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com
If {YourDateField} in Dateadd("d",-91,CurrentDate) to {Dateadd("d",-120,CurrentDate) then {YourAmountField} else 0
Write a similar formula for over 120 days.
let me know if you have any questions. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com
-
1
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question