If(DATE_TO = '_________', Today(), DATE_TO) as DATE_TO,
(html, utf8, UserAgent is 'Mozilla/5.0', embedded labels, table is @1);
,Min(DATE_FROM) as min_DATE_FROM
,Max(DATE_TO) as max_DATE_TO
Group By EMPL_NO
The script is above.
I have only changed value If(DATE_TO = '_________', Today(), DATE_TO) as DATE_TO. You can easily convert it back to '_________' instead of Today().