I've had similar problems with Date and DateTime parameters so now I use TimeStamp instead. ParamByName('DT').AsSQLTimeStamp := DateTimeToSQLTimeStamp(Trunc(EffluentRec.DT)); should work. Cheers, Carl