Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Prompt to get data for previous 5 days

Hi All,

I am woking on BO XI 3.1 with informix database.

Requirement: To get the data for previous 5 days including the day user selected in the prompt.

Example: Suppose we have an object named "sys date" and we have created the prompt on sys date , now when the user select any value (let's say 15/09/2014), then the output should contain the records for previous 5 days(i.e from 10/9/2015 to 15/09/2014)

Please Suggest.

Thanks in advance

Regards,

Rishabh

Former Member
Former Member replied

Thanks everyone for the help.

@Neil: Thanks ... MYD function worked.

Here is the solution for those having the same requirement:

Created a conditional object with below syntax and placed it into the filter pane.

@Select(Class\Object) BETWEEN  MDY(month(@Prompt('Entry Date:','D','Class\Object',mono,free)),day(@Prompt('Entry Date:','D','Class\Object',mono,free)),year(@Prompt('Entry Date:','D','Class\Object',mono,free)))-5 UNITS DAY AND @Prompt('Entry Date:','D','Class\Object',mono,free)

Replace the 'Class\Object'  with your date object.

Thanks and Regards,

Rishabh Singhania

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question