Skip to Content

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

BOXI3.0: Formula for subtract/deduct one day or more from date field

Greetings. Its Alias.

I have one question. Actually I already post this question but at designer forum.

I am using SQL.

Example I have Order Date field and from this field I want to subtract the date by minus one day or two days or three days, etc.

I got the solution for designer (example):

DATEADD (dd , -3, EPJ_IPMS.dbo.DO_DATA.DO_DATE_D)

But at webi level it does not work.

I also do not understand why at designer and webi level may have different SQL select statement.

Can someone help me please.

Best regards,

Alias

Former Member
Former Member replied

Hi Alias,

Just use this formula

RelativeDate([date_object],day_number)

here day_number be positive or negative.

if your [order date] field is come through a universe as a object then you can easily add/sub date by using that formula:

Hope it will work

Thanks

0 View this answer in context

Helpful Answer

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