Morning all -
I have a basic header on a report that prints the end-user selection criteria. One of the selections at the WebI prompt screen is a date range where you select From & To date. When I print values selected from the date range prompt into the header I see two issues: 1) it adds a day to the From & To date values 2) it adds 12:00:00 AM at the end of From & To date values. I will add examples & screenshots below:
WebI query prompt box:
From date: 1/11/2015
To date: 1/12/2015
WebI report Header:
Date range: 1/12/2015 12:00:00 AM - 1/13/2015 12:00:00 AM
Code used above -> "+"Date Range: "+UserResponse("Date Range")+"
Anyway to resolve the above two issues?