Jul 11, 2001 #1 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?
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?
Jul 12, 2001 #2 kenhamady Instructor Sep 10, 2000 8,794 US 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 http://www.kenhamady.com/On-site custom Crystal Reports Training and Consulting. Quick Reference Guide to using Crystal in VB. Upvote 0 Downvote
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 http://www.kenhamady.com/On-site custom Crystal Reports Training and Consulting. Quick Reference Guide to using Crystal in VB.