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!
Recent content by cmarshal
-
Testing for List of Text Strings in Database Field
Thanks, David! Where do I enter the stringvar array numbers_to_test := ['603555','605988','708333','99999'.............]; ?? Is this a parameter, formula, or part of the select formula itself? Also, I'm really trying to test the opposite way -- to seek if any of the array items are in the...- cmarshal
- Post #3
- Forum: Business Objects: Crystal Reports 4 Other topics
-
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
Hi Ken: Here's an example of the time field: DateTime (2001, 1, 11, 15, 23, 6) This would be 3:23 and six seconds pm today, January 11. I'm trying to identify all records with a time between 3:18 and 3:28, today. Thanks! -clint- cmarshal
- Post #3
- 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
