Setting default DateTime value in Prompt

[Former Member]

Dear All,

I have a report for which I need to enter two prompts with values during runtime:

1. Start Date

2. End Date

I want the above to be automatically populated as below:

1. Start Date - First DateTime of previous month - 9/1/2016 12:00:00 AM

2. End Date - Last DateTime of previous month - 9/30/2016 11:59:59 PM

I tried setting up the prompt with default value for the End Date using the following formula

RelativeDate(ToDate(FormatDate(CurrentDate();"yyyyMMdd");"yyyyMMdd");-DayNumberOfMonth(CurrentDate())+1-(1/86400))

But when I run the report the End Date is showing up as "9/30/2016 12:00:00 AM"

Please suggest.

[sateesh_kumar1]

Hi ,

You can't populate values for prompts with values from webi report.

This has to be done at Universe (from BI 4.1 SP6) or at BW if it is BEx.

http://scn.sap.com/community/businessobjects-web-intelligence/blog/2015/07/17/how-to-use-new-feature...

[Former Member]

I am setting the default value in Prompt in Universe only(IDT). Thought it was too obvious to mention.