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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Testing for List of Text Strings in Database Field
Working with data from our telephone system, I am tring to select records where any one of several telephone exchanges is included in the Dialed Number. I have gotten the formula to work where I enter a single area code and exchange combination as a parameter (ie: 603555) using the following...- cmarshal
- Thread
- Replies: 4
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Adding 5 Minutes to Time
I'm trying to run a query that finds all phone calls within 5 minutes before or after a time that's entered as a parameter. How do I create "start_time" and "end_time" values by adding and subtracting 5 minutes to the entered time? What do the formulas look like...- cmarshal
- Thread
- Replies: 3
- Forum: Business Objects: Crystal Reports 4 Other topics
