Hi,
I am struggling to pass the date range value to the detail report.
The two variables v_start_date and v_end_date have been created to get convert the date fromat from “MM/dd/yyyy hh:mm:ss a” to “MM/dd/yyyy” but the dates are not passing to the detail report.
How to pass the date values from the parameter to the open doc?
Please suggest
="<a href="…/…/opendoc/openDocument.jsp?iDocID=AQOIoZentnlIno69rNXJNR8&sIDType=CUID&sType=rpt&sRefresh=Y&lsSMRN="+URLEncode(""+[MRN])+"&lsSFromDate="+URLEncode(""+[v_start_date])+"&lsSToDate="+URLEncode(""+[v_end_date])+"" title="" target="_blank" nav=“doc”>Patient Itinerary Report"
The v_start_date and v_end_date are variables and have the below syntax
v_start_date=FormatDate(ToDate(UserResponse(DataProvider([MRN]);“Enter FromDate:”);“MM/dd/yyyy hh:mm:ss a”);“MM/dd/yyyy”)
v_end_date =FormatDate(ToDate(UserResponse(DataProvider([MRN]);“Enter ToDate:”);“MM/dd/yyyy hh:mm:ss a”);“MM/dd/yyyy”
Thanks
s7jyothi (BOB member since 2008-09-07)