Really? You used SQL to do that?

          <cfquery name="loadDateInfo" datasource="#MainDSN#"
          username="#MainUsername#" password="#MainPassword#">
               SELECT datediff(d,getDate(), '#loadPendingPolicy.effectiveDate#') as FutureDate
          </cfquery>