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.
Arif Arifuzzaman replied
Just use this formula
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