QuerySetCell gotch ya.

[rlarson]

Ran into this little problem on MX.

I was using:
<cfset available_date = dateformat(now(), &quot;mm/dd/yyyy&quot>
<cfset temp = QuerySetCell(qryWidgets, &quot;AvailableDate&quot;, available_date, qryWidgets.currentrow)>
to add a formatted date value to a query. When I went to use the value it returned: {ts 2003-03-20 00:00:00}

Using &quot;##&quot; around available date forced the value to be a string.
<cfset temp = QuerySetCell(qryWidgets, &quot;AvailableDate&quot;, &quot;#available_date#&quot;, qryWidgets.currentrow)>
It then returned the desired result of 03/20/2003.

Hope this helps someone out there.