Skip to Content

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

Dateadd function equivalent in BO

Hello All,

I want to create few Filter objects in Universe. I have the logic in SQL sever DateAdd function. Is there any such equivalent function in Business Objects that I can use ?

Universe filter 1: Reporting Period

dbo.RPT_YEAR_MONTH=@Prompt('Enter values for Rpt Year Month:','N','Folder\MeasurePractice\Rpt Year Month',Mono,Constrained)

input value : 201406

Universe Filter 2: promptDateMinusThreeMonths

dbo.RPT_YEAR_MONTH= dateadd(month, -3, [promptDate])  ie   Dateadd(month, -3, @Reporting Period).

Thanks All.

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