Scheduling report with prior month's results

general discussion
2

Create universe objects for “first day of last month” and “last day of last month” - this topic shows how: DB-specific Relative Dates SQL Server, Oracle, Netezza, DB2

In your report - instead of your prompt, just put

where date between first_day_of_last_month_object and last_day_of_last_month_object

Debbie

Debbie :uk: (BOB member since 2005-03-01)