Hi, As suggested I have used this code, <cftry> <cfset fromDateObject=parsedateTime(datefrom)> <cfset toDateObject=parsedateTime(dateto)> <cfset fromDateTimeString=dateFormat(fromDateObject, "yyyy/mm/dd") & " " & timeFormat(fromDateObject, "HH:nn:ss")> <cfset toDateTimeString=dateFormat(toDateObject, "yyyy/mm/dd") & " " & timeFormat(toDateObject, "HH:nn:ss")> <cfquery name="PrepareMultiReportData" datasource="#datasource#" username="#Session.UserName#" password="#Session.password#"> BEGIN dbo.multi_report_pkg.run_multi_report(#Session.multi_rep_id#, '#Session.UserName#', #multi_report_def_id#, TO_DATE(<cfqueryparam value="#fromDateTimeString#" cfsqltype="VARCHAR" maxlength="28">,'YYYY/MM/DD HH24:MI:SS','AMERICAN'), TO_DATE(<cfqueryparam value="#toDateTimeString#" cfsqltype="VARCHAR" maxlength="28">,'YYYY/MM/DD HH24:MI:SS','AMERICAN'), #period#); END; </cfquery> ------------------------------------------------------------------------------ The error I get is shown below
... View more