Displaying a date in report minus 3 months

[system]

Hi

I am relatively new to Business Objects and have got a little stuck in a report I am trying to extract.

I have a date field (called Start) which I need to report on but I also need to report the same date field less 3 months in the same report.

EXAMPLE

Account_number, Start_date, True_Start_Date
1 28/07/2019 28/04/2019
2 18/07/2019 18/04/2019

As you can see from the example above the True_start_Date is exactly 3 months prior to the start_date.

Hope this makes sense.

---

steverc (BOB member since 2019-08-21)

[system]

Hi Steve,

You can find your answer here:
https://answers.sap.com/questions/7572800/how-to-calculate-month-1-in-web-intelligence-31.html

---

ndam (BOB member since 2016-11-09)

[system]

Thank you for pointing me in the right direction, the link you have sent works perfectly for what I need.

---

steverc (BOB member since 2019-08-21)