if (len(trim(form.meeting)) > 0

theDate = dateAdd("d", 2, now();

else

theDate = something.

But it's not that simple.  You might also have to ensure that form.meeting actually is a date and if so, that it meets whatever other criteria you have.  Finally, don't use dateformat in this situation.  It's a display function that returns a string.  You want to send a date object to your db.

I wouldn't go changing many things at once. That would lead to complexity. Start with your original code, and just tweak it a little, using the suggestions. For example

<!--- UPDATE QUERY --->

<cfif isDefined("form.UPDATEADDBTN")>

    <cfif FORM.ENTID GTE 1>

        <cfset isCOMMENTSNull = iif(len(trim(form.COMMENTS)) EQ 0, true, false)>

        <cfset meetingDate = trim(form.meeting)>

        <cfif not isDate(meetingDate)>

            <cfset meetingDate = dateAdd("d", 2, now())>

        <cfelse>

            <!--- Here, apply Dan's advice to convert from string to datetime object. Use, for example, parseDatetime, createdate or createdatetime --->

            <cfset meetingDate = parseDatetime(meetingDate)>

        </cfif>

    <CFQUERY name="updatecompany" datasource="salesdb">

        update COMPANY

        SET COMMENTS = <cfqueryparam cfsqltype="cf_sql_longvarchar" value="#trim(form.COMMENTS)#" null="#isCOMMENTSNull#" />,

        MEETING = <cfqueryparam cfsqltype="cf_sql_timestamp" value="#meetingDate#" />

        WHERE ENTID = <cfqueryparam cfsqltype="cf_sql_integer" value="#FORM.ENTID#" />

    </CFQUERY>

<cfelse>

Dan Bracuk wrote:

 

Regarding, "

I get this error in coldfusion?:

Cannot convert the value of type class coldfusion.runtime.OleDateTime to a boolean"

 

What is the line of code creating this error?

The error was caused by the attribute null="#meetingDate#". I had suggested that this attribute be left out altogether.