Skip to Content
Former Member
Jul 31, 2007 at 06:48 PM

`Date` between `when` and `when + 3 days`.. How to Implement.


Post Author:

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?