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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Aging by business days

Status
Not open for further replies.

jfcox

Programmer
Jul 11, 2001
44
US
I need to calculate the age of item in terms of working days only. So, the usual Aged0to30, etc. doesn't work. Has anybody done this?
 
See my FAQ in the general CR forum. There is a formula there that calculates the work days between two input dates.

You can then create aging columns by saying:

If {ageformula} in 30 to 60
then {ARAmount}
else 0

Or something like that

Ken Hamady
On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top