lholodnak
IS-IT--Management
- Mar 26, 2004
- 21
Hi, I'm using crystal 10, with oracle tables and I don't have the luxury of having a holiday/workweek table created for me. I need to report that calculates the how long it takes for a data entry clerk to key in the work order once they get it, but I need to exclude holidays and weekends. I have a table that has DateTime wo received: 2004, 07, 09, 00, 00 and Datetime the wo record was updated: 2004, 07, 09, 10, 20. I have the following formulas:
@Date Difference {WORK_ORDER.LAST_ATTR_UPDT_DT} - {WORK_ORDER.REC_TM_DT}
@Convert date to number ToNumber ({@Date Difference})
@Count of 2 or less days If {@Convert date to number} <= 2 then 1 else 0
Now I need to exclude holidays and and weekends, can someone help me. I have looked at some of the tips on holidays and weekdays, but I'm unsure of how to incorporate in my scenario. Thanks, Lisa
@Date Difference {WORK_ORDER.LAST_ATTR_UPDT_DT} - {WORK_ORDER.REC_TM_DT}
@Convert date to number ToNumber ({@Date Difference})
@Count of 2 or less days If {@Convert date to number} <= 2 then 1 else 0
Now I need to exclude holidays and and weekends, can someone help me. I have looked at some of the tips on holidays and weekdays, but I'm unsure of how to incorporate in my scenario. Thanks, Lisa