<br />
<b>Notice</b>:  Undefined index: scenario in <b>C:\xampp\htdocs\WAKOLIMA\RAEXTERNAL\getTripJournal.php</b> on line <b>9</b><br />
Error in executing query. SELECT DISTINCT
  sales.snentfact AS Diario
FROM
  salesshippingstat sales
INNER JOIN salesshippingjour ON sales.snentfact = salesshippingjour.snentfact
AND sales.dataareaid = salesshippingjour.dataareaid
INNER JOIN salestable ON sales.salesid = salestable.salesid
AND sales.dataareaid = salestable.dataareaid
INNER JOIN custtable ON salestable.invoiceaccount = custtable.accountnum
AND salestable.dataareaid = custtable.dataareaid
WHERE
  (
    sales.dataareaid = 
  )
AND (
  SALES.FECHAENTREGAREPARTIDOR > DATEADD(day, -5, GETDATE())
)
AND (sales.snentfact != '')
ORDER BY
  diario DESCArray
(
    [0] => Array
        (
            [0] => 42000
            [SQLSTATE] => 42000
            [1] => 102
            [code] => 102
            [2] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near ')'.
            [message] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near ')'.
        )

)