on 07-31-2007 7:48 PM
Post Author: da@online-buddies.com
CA Forum: Data Connectivity and SQL
I have this statement I need to incorporate into my report to properly select my records. Date(`TableA`.`created`) between `TableB`.`when` and `TableB`.`when`+ interval 3 day My SystemMySQL 5.0 ODBC 3.15.16 connector (System DSN)BO Server (using Business Views and Crystal Reports XI) I have tried to created a SQL Expresion in the Data Foundation, but it craps out. I tried to create filers, but it doesn't allow the variety mix of fields.Any suggestions?
Post Author: SKodidine
CA Forum: Data Connectivity and SQL
You could try the +3 days as a DATEADD. Like this:
Date(`TableA`.`created`) between `TableB`.`when` and DATEADD(day, 3, `TableB`.`when`)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
10 | |
8 | |
8 | |
6 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.