I am trying to create a formula to count the number of weekdays(Mon-Fri) in a date range. My effort so far is:
Local NumberVar Weekdays :=0;
Local NumberVar index ;
for index := {DBTable.Date1} to {DBTable.Date2} do
(
if(DayOfWeek(index)in 2 to 6 )then
Weekdays := Weekdays + 1
)...
Does anybody know if you can automatically have the report data refreshed when you open the report rather than having to click refresh every time. If so how do I do it?
Please help!
dazf
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.