overlap de fechas

overlap de fechas

    @api.constrains('tax_id', 'date_from', 'date_to')
    def _check_date_overlap(self):
        for record in self:
            if record.date_from and record.date_to:
                # Verificar que no haya superposición de fechas con otro registro
                overlapping_records = self.search([
                    ('tax_id', '=', record.tax_id.id),
                    ('id', '!=', record.id),  # Excluir el propio registro
                    ('date_from', '<=', record.date_to),
                    ('date_to', '>=', record.date_from)
                ])
                if overlapping_records:
                    raise ValidationError("..")