Skip to Content
0
Former Member
Jan 21, 2015 at 03:50 PM

UserResponse function on DateRange variable shifts day & adds timestamp

200 Views

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?

Thanks!