dfgrumpy
10/24/2022, 1:18 AM<cfset workdate = '*****'>
<cfset workdate = dateformat(#qry.closingdate#, 'mm/dd/yyyy')>
<cfif isdefined('qry.closingdate') and len(qry.closingdate) gt 0>
<cfset workdate = dateformat(#qry.closingdate#, 'mm/dd/yyyy')>
<cfelse>
<cfset workdate = ''>
</cfif>
gavinbaumanis
10/24/2022, 3:15 AMAdam Cameron
mm/dd/yyyy
as a date format. Ugh.