Skip to Content
0
Former Member
Sep 24, 2008 at 05:57 AM

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

344 Views

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