Max date before UserResponse

building reports webintelligence
1

How do I get the most recent date BEFORE the UserResponse date entered? Thanks.

curious1 (BOB member since 2008-08-29)

2

Not sure how (or if) to do this from the universe level :?: but this code should work for you at the report level (You need to update with your prompt);

[list]=RelativeDate(ToDate( UserResponse(“Enter The Date:”);“MM/dd/yyyy h:mm:ss a”) ;-1)[/list]

Joe Szabo :us: (BOB member since 2002-08-19)

3

Thanks for the suggestion. This variable in the report gets a #ERROR. I have checked the input date data type and the column values, and they match the variable’s data type. Any ideas why I get this error? Thanks again.

curious1 (BOB member since 2008-08-29)

4

=RelativeDate(ToDate( UserResponse(“Enter The Date:”);“M/d/yyyy h:mm:ss a”) ;-1)

It should be one M, and one d.

Lilly J (BOB member since 2002-08-22)

5

That’s odd, I’m able to get the date to display fine without the error (with either my code or Lilly’s). Another bug :?:

XI3.1 :wave:

Correction - Possibly belongs to WebIntelligence Layer forum

Joe Szabo :us: (BOB member since 2002-08-19)