Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Count Occurence of a Weekday Between 2 Dates
Thanks lbass! I knew there was a simple solution. Here is my formula that works, I placed it in the report header so the value is now available for comparison on the first record: local numbervar ParamWeekday; local numbervar DayCount; If {?DaysOfWeek} = "Sun" then ParamWeekday:= 1 else...- jodan
- Post #4
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Count Occurence of a Weekday Between 2 Dates
I have 3 parameters in a report: 1. {?FromDate} 2. {?ToDate} 3. {?DayWeek} (a 3 letter representation of a day i.e. "Sun") I need to calculate the number of times the specific {?DayWeek} day occurs between {?FromDate} and {?ToDate}. If the {?DayWeek} occurs on the {?FromDate} or {?ToDate}, it...- jodan
- Thread
- Replies: 3
- Forum: Business Objects: Crystal Reports 1 Formulas
