Utiliza CAST, que yo sepa, no puedes usar la función date en SQL.
sql="select distinct coord,central,tele,dispo+subdispo,causa+subcausa,s ubstr(tclo,7,2)+'/'+substr(tclo,5,2)+'/'+substr(tclo,1,4)+' '+substr(tclo,9,2)+':'+substr(tclo,11,2),cleaid1,r ep1,ca1,arm1 from acumnac as t1 where "&_
"tele=(selec tele from acumnac where t1.tclo<acumnac.tclo and acumnac.causa<>'5' and acumnac.causa<>'7' and acumnac.dispo<>'19' and acumnac.dispo<>'17' and acumnac.dispo<>'13' and acumnac.causa<>'6' and acumnac.tclo >='" & ano1+mes1+dia1 & "' and acumnac.tclo<='" & ano2+mes2+dia2 & "') "&_
"and clsid='" & dac & "' and area1='" & coord & "' and CAST(t1.tclo as datetime) - CAST(acumnac.tclo as datetime) < 30 "&_
"and t1.causa<>'5' and t1.causa<>'7' and t1.dispo<>'19' and t1.dispo<>'17' and t1.dispo<>'13' and t1.causa<>'6' "&_
"order by t1.tele,t1.tclo "
Pruébalo, a mi CAST me funciona de maravilla. Si tienes problemas busca información de CAST o CONVERT, que son las funciones de conversión que soporta SQL .
Suerte!!
:cantar: