SELECT eo.* FROM ExtranetOfertaPuntoVenta eopv INNER JOIN ExtranetOferta eo ON eopv.IdExtranetOferta = eo.IdExtranetOferta WHERE eo.Activo = true AND IdPuntoVenta = AND CDate(FechaIni) <= CDate('21/12/2024') AND CDate(FechaFin) >= CDate('21/12/2024') ORDER BY eo.Orden ASC, eo.IdExtranetOferta ASC
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'eo.Activo = true AND IdPuntoVenta = AND CDate(FechaIni) <= CDate('21/12/2024') AND CDate(FechaFin) >= CDate('21/12/2024')'.