[thelist] Setting Default Date Values in SQL Server through A SP

[Anthony Baratta]

Rob...

Does the table allow Nulls on the date/time field?

Also, you need to make sure that "Null" is not "quoted".

e.g. Field_DateTime = Null

   if (isNull(dict("DateTimeName")) or dict("DateTimeName") = "") then
      strQuery = strQuery & "Field_DateTime = Null "
   else
      strQuery = strQuery & "Field_DateTime = '" & dict("DateTimeName") & "' "
   end if

Hope that helps.
--
Anthony Baratta
President
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."