I want to list upcoming events stored in database for the next 15 days

[mxarievilo]

I'm trying this:

$recordset = $conexao->Execute("select * from PRO where CDate(PRO_DTCAD)+PRO_DURAC BETWEEN DateAdd(\"d\", +15, NOW()");

PRO_DTCAD is REGISTER DATA
PRO_DURAC is DAYS TO EXPIRE

But:

PHP Fatal error: Uncaught exception 'com_exception' with message '<b>Source:</b> Microsoft JET Database Engine<br/><b>Description:</b> Missing ), ], or Item in query expression 'CDate(PRO_DTCAD)+PRO_DURAC BETWEEN DateAdd("d", +15, NOW()'.' in E:\...\consulta_vencendo.php:7
Stack trace:
#0 E:\...\consulta_vencendo.php(7): com->Execute('select * from P...')
#1 {main}
thrown in E:\...\consulta_vencendo.php on line 7

I tried too:

$recordset = $conexao->Execute("select * from PRO where CDate(PRO_DTCAD) Between DateAdd(\"d\", -15, NOW()) AND DateAdd(\"d\", 15, NOW())");

Fatal error: Uncaught exception 'com_exception' with message '<b>Source:</b> Microsoft JET Database Engine<br/><b>Description:</b> Tipo de dados imcompatível na expressão de critério.********' in C:\wd\xampp\htdocs\nf\admin\consulta_vencendo.php: 6 Stack trace: #0 C:\wd\xampp\htdocs\nf\admin\consulta_vencendo.php( 6): com->Execute('select * from P...') #1 {main} thrown in C:\wd\xampp\htdocs\nf\admin\consulta_vencendo.php on line 6

********Data type incompatible

Can someone that understand php and MSACCESS help me?