Hi,

How get max date value a field in database.

code:

            lo_line = self.env['lo.line'].search(['&',('employee_id','=',vals['employee_id'])])

            if lo_line:                

 last_date= max(d for d in lo_line.date)          ?????

            linee_d = datetime.strptime(str(last_date), "%Y-%m-%d").date()           

            last_d = (current_date - linee_d).days        

            last_lo_mon = int(last_d/30)         

            if last_lo_mon < 12:      

              raise UserError("error")

        return False 

error:   last_date= max(d for d in lo_line.date) 

    raise ValueError("Expected singleton: %s" % self)