Am using SAP Business Objects Web Intelligence. At present am using Report Date as Manual Prompt. here Report Date format as YYYYMMDD , I would like to consider the (today's date -1) has to go as a parameter. we have the Report Date object which has the values till 20161231. But when ever I run the report it has to take only today's date -1 in this format (YYYYMMDD).Back end is MS SQL Server.
I have tried many possibilities, but didn't work.