Subtract Months

building reports webintelligence
1

How do I subtract 1 month from the current date in webi ? I don’t mean 30 days, I mean 1 month.

Thanks in advance.

mountainman (BOB member since 2008-09-02)

2

First day of month = ToDate(“01/” + MonthNum + “/” + YearNum; “dd/MM/yyyy”)

LastDayOFLastMonth = RelativeDate(First day of month ; -1)

Mick

mikca :australia: (BOB member since 2005-12-16)

3

Hi,
Is it possible for you to make a condition in the universe and also what database you are on?

Omkar Paranjpe :us: (BOB member since 2006-02-13)

4

mikca,

Your formula worked.

Thanks

mountainman (BOB member since 2008-09-02)

5

i tried the same formula but it gave MonthNum unrecognized. Can you share what approach you followed…
Thanks
Aniket

aniketp :uk: (BOB member since 2007-10-05)

6

anikept
Why not open your variable editor, open the functions page and then search for a function starting with monthnum?

If you are going to work as a developer you must expect to do some developing, some experimenting and some discovering.

Mick

mikca :australia: (BOB member since 2005-12-16)

7

I am working as a developer only and also i checked for the functions , and couldn’t find,then only i posted. And I think every one here is doing development work. Regarding experimenting and discovering, i think if one is working with Business objects has to always face this Phase, which I am too facing.

Regards
Aniket

aniketp :uk: (BOB member since 2007-10-05)

8

Aniket, Mick meant using MonthNumberOfYear() and Year() functions. You can easily pick up them from the list of functions available.

Jansi :india: (BOB member since 2008-05-12)