I've just discovered Firebird and I'm using VB to experiment with it.
This code works fine

myDate = Format(Now(), "mm/dd/yy hh:mm")
sql = "INSERT INTO MYTABLE (MYDATE) VALUES ('" & myDate & "');"

as long as myDate is a date. If I set myDate = NULL the statement
causes an error and I know why the error is occurring.

What I need to know is how to write this statement to take into
account the possibility that myDate is NULL.

Thanks