question, from an api, few of teh fields i am getting the data in array of srructts as: expirationdue: undefined i am inserting that code in the database, i am trying to use the null attribute but it keeps throwing error on this line i am using the cfqueryparam as: <cfqueryparam cfsqltype="timestamp" value="#data['expirationdate'])#" null="#!date(data['expirationdate']#">

your code has at least 2 syntax errors. date(...) isnt a function afaik. maybe you meant isdate? and youre missing closing parenthesis. people cant help you effectively unless you post real example code

Yes it’s a typing mistake