UPDATE caicobs_rep
          SET obs_date=date_format(date_first,'%Y-%m-%d')
          WHERE obs_date='0000-00-00'<br><br>DONE