BusinessObjects Board

Last day of month

Hi - I am using BO XI 3.1 webi

I am stuck in creating a variable that pulls last month last day data, if last day of last month is Sunday then it should pull data for previous day ie Saturday

Pls help


muralidwh (BOB member since 2015-04-24)

Would you not be best off doing this in a filter at the universe level?


Damocles :uk: (BOB member since 2006-10-05)

Hi - I have Last Day Of Month ie 2014-12-30 in my database. If this falls on sunday, I need to consider 2014-11-29

if I can create at universe also it is fine

help appreciated


muralidwh (BOB member since 2015-04-24)

check this sticky post DB-specific Relative Dates SQL Server, Oracle, Netezza, DB2


haider :es: (BOB member since 2005-07-18)