cfset no longer works in 2016

BadMrFrosty You shouldn't be able to update the value of a query "cell" that way.  It might help to think of a query result as an array of structs (it's actually more complicated under the hood, but in many ways it does behave this way).  Each row of the query is one item in the array, and the item is a struct containing key/value pairs matching your query columns and their values.  Even if your query only returns one row, it would still be an array (it would just have one struct item).  So to set the value of that cell, you would have to reference the location in the array (aka the row number).  So

<cfset check.Date = DateFormat(check.Date, "short")>

should be

<cfset check[1].Date = DateFormat(check.Date, "short")>

where check[1] references the first row of the query.  Unless, of course, the query has more than one row, in which case you have to specify the correct row (or more likely, loop over the query and do it to every row).

However, as haxtbh‌ and WolfShade‌ have indicated, it would be better to fix the formatting in the SQL statement.

It's working. Can you try the below example.

<cfset abc= now()>

<cfoutput>value of abc = #abc#</cfoutput>

Regards,

Anit Kumar