Replace 'datefield' with actual name of the field with empty date in the code below.

SELECT * ;
  FROM employees ;
  WHERE employees.emp_dept = "118";
  INTO TABLE newreport

<b>REPLACE ALL datefield WITH DATE()</b>
LOCATE   && Move pointer back to the top of the table

If you don't have this field in the source table

SELECT *, DATE() AS today ;
  FROM employees ;
  WHERE employees.emp_dept = "118";
  INTO TABLE newreport