Thanks kray4660 for your support!
In fact my problem is I need to get a result from TODAY and -7 days of working including today and exclude SAT and Sun weekends as well, and I cannot find any kind of information on google.
Just the normal case using 2 different defined dates, nothing else.
Hello there,
So I have a report that I need to get the last 7 days of Work counting from today, excluding Saturday and Sunday.
I'm new to Crystal and I searched on several websites and the only thing I get is with 2 intervals dates,
Using this query works
SELECT COUNT(*) FROM T_Orders WHERE...
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.