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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Date Range Select Problem
Version: Crystal 10 Database: SQL I currently have a report that uses: {Deal_Jacket.title_comp_pend} in cdatetime(year(currentdatetime),month(currentdatetime),day(currentdatetime-1),7,0,0) to cdatetime(year(currentdatetime),month(currentdatetime),day(currentdatetime),7,0,0) - In order to...- mipsfuct
- Thread
- Replies: 6
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Restrict time range from datetime selection
Hello, I have what appears a simple problem but I cannot seem to resolve it on my own. I have to generate productivity reports that limit the evaluation time from (Mon 7:00 AM) to (Sun 7:00 AM). I know how to get Mon - Sun : ({Deal_Jacket.Billing_Comp_Pend} in (currentdate -...- mipsfuct
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 1 Formulas
