risolto così:

codice:
oggi = date()

SELECT ... FROM tab WHERE data BETWEEN '"&oggi&" 00:00:00.000' AND '"&oggi&" 23:59:59.997'