• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• Keeps SQL NULL Dates NULL instead of defaulting to 1/1/1900 - using SQL string - also avoid errors

Keeps SQL NULL Dates NULL instead of defaulting to 1/1/1900 - using SQL string - also avoid errors

Keeps SQL NULL Dates NULL instead of defaulting to 1/1/1900 - using SQL string - also avoid errors with different date formats - SQL loves

API Declarations


' and a field called mydate in a table called mytable



Rate Keeps SQL NULL Dates NULL instead of defaulting to 1/1/1900 - using SQL string - also avoid errors

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

strSQL = "UPDATE mytable SET " & _
         IIf(Len(strDateField) > 0, _
             "mydate = " & format(cdate(strDateField), "yyyy-mm-dd"), _
             "mydate = " & "NULL")