If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Help with filter for Previous month's data.

Started by KEKeogh, 23 Apr 2009 01:29:42 PM

Previous topic - Next topic

KEKeogh

Okay, so I'm using the following formula to pull just the previous month's data:
_first_of_month(_add_months(current_date,-1)) and _add_days(_first_of_month(current_date),-1)

This seems to work fine on a general report pulling all data including the 1st and last of the previous month.

For some reason when I put this filter with a more detailed report.  The data for the last day of the Previous month doesn't show up.  Almost like it's looking for the last day of the previous month at midnight.

My fear is that one time a general report I create may no grab the last day's data.  Is there a way I can add a time constraint into the formula?

Thanks
Kathie