Inserting/updating with empty date field

takabyte · December 22nd, 2004, 07:32 PM

I am posting data from a form into an Access database in ASP, inserting or updating records. Several of the fields in the table are date fields. The form data may include a date in one or more of those fields, or one or more may be left empty. How can I develop a variable that will post whether containing a date or Null, so that I can use the construction datefield=#" & variable & "#? Or is there some other way to accomplish this?

nashnash · December 23rd, 2004, 05:25 AM

Function CheckDate(strDate)
    IF IsDate(strDate)Then
        CheckDate= strDate
    ELSE
        CheckDate= NULL
    END IF

End Function

----call this as ----

CheckDate(strDate)

Thanks
Nash

Jonax · December 23rd, 2004, 05:59 AM

If you change Nash's function slightly, you can call it as described...

Code:

Function CheckDate(strDate)
    IF IsDate(strDate)Then
        CheckDate= "'#" & strDate & "#'"
    ELSE
        CheckDate= NULL
    END IF     
End Function

strSQL = "... datefield = " & CheckDate(dtDateVar)

takabyte · December 23rd, 2004, 02:14 PM

Thank you. With some modification, the method you suggested worked.