You had a look at R6 and the overhaul of the formula language. Nice updates. For calculation of working days @Businessdays replaces a lot of legacy script... However your client base is on R5. Don't worry you can have it in R5... Thanks to the power of lists.
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
R6: tmpWeekEnd:= 1:7; tmpHolidays := [01/01/2003] : [15/01/2003] : [16/02/2003] : [28/05/2003] : [04/07/2003]; @BusinessDays(FirstDay; Lastday;tmpWeekEnd;tmpHolidays) R5: tmpWeekEnd:= 1:7; tmpHolidays := [01/01/2003] : [15/01/2003] : [16/02/2003] : [28/05/2003] : [04/07/2003]; REM "Create a textlist that contains all days in the period"; tmpDatelist := @Text(@Explode (@TextToTime(@Text(Firstday)+" - "+@Text(Lastday)))); REM "Replace the holidays out of the list"; tmpNoHolidays := @TextToTime (@Trim(@Replace(tmpDatelist; @Text(tmpHolidays);""))); REM "Remove Weekends"; tmpWeekdays := @Text(@Weekday (tmpNoHolidays)); tmpWorkdays := @Trim(@Replace (tmpWeekdays;@Text(tmpWeekEnd);"")); @Elements(tmpWorkdays)