Formula to calculate as of date

system · June 30, 2011, 7:40am

Hi I need to a prompt “As of Date” which should give me the data for the last 12 months till that date… eg. if the as of date entered is 30/06/2011, I need to display data from 30/06/2010 to 30/06/2011 ie. last 12 months data … Also could u pls suggest a formula for this how could i do it … anything would do at universe level or query level … I also need an as of date prompt which will give me the last 12 weeks data just as months

BO_USER1 (BOB member since 2011-03-27)

system · June 30, 2011, 8:02am

Hi ,
This can be achieved with use of conditional object on universe level,where you can keep the Start Date as fixed.
Cant remember exact formula now.

swap_l (BOB member since 2009-04-09)

system · June 30, 2011, 1:38pm

Hi,

Check this article by Dave.

M H Mohammed (BOB member since 2010-06-16)

system · June 30, 2011, 2:53pm

It is also worth considering the following topic

https://bobj-board.org/t/152613 which talks about formulas for relative dates

dfoster99 (BOB member since 2010-11-05)