Boh......ho fatto così:

codice:
dtg=date()
GG=day(dtg)
MM=month(dtg)
AA=year(dtg)

dtg2=mm&"/"&gg&"/"&aa

Squeryt="SELECT rep, dat, num from cartelli where rep= '"& bli &"' and Int(dat)=#"& dtg2 &"# ORDER BY dat desc ;"
E funzica.