Apr 8, 2003 #1 DaveDup MIS Mar 12, 2003 3 US I am looking for a formula to calculate business days between two dates. Can anyone please help?
Apr 8, 2003 1 #2 DataDog Technical User Jun 19, 2002 190 US Try Something like this: DateTimeVar d1 := {LA966.VEH_USE_BGIN_DT}; DateTimeVar d2 := {LA966.VEH_USE_END_DT}; datediff("d",d1,d2) -datediff("ww",d1,d2,crSaturday) -datediff("ww",d1,d2,crSunday) DataDog 'Failure Is Not An Option' Upvote 0 Downvote
Try Something like this: DateTimeVar d1 := {LA966.VEH_USE_BGIN_DT}; DateTimeVar d2 := {LA966.VEH_USE_END_DT}; datediff("d",d1,d2) -datediff("ww",d1,d2,crSaturday) -datediff("ww",d1,d2,crSunday) DataDog 'Failure Is Not An Option'