Skip to Content
0
Jun 23, 2020 at 12:30 PM

UserResponse convert to date

57 Views

Hi,

In my report, I have two prompts which I ask the user to enter:

  • Specify COB From
  • Specify COB Till

Then in my report, I use the function UserResponse("Specify COB From") to show it in my report header.

This was all working fine until I need to now set a schedule for my report. Meaning, it needs to run automatically every Monday so I now need to use dynamic dates in my prompts instead of actual dates. I want to show previous week's data hence I have been able to select WeekStart-1 and WeekEnd-1.

Here is what my prompt looks like:

But now in my report I get errors in the variables that made use of the function "UserResponse":

Can someone please advise me how I can get it working?

Thank You,

Jay

Attachments

capture.png (245.7 kB)
capture.png (142.9 kB)
capture.png (14.6 kB)
capture.png (146.8 kB)