Schedule Job for Month End Reports

[tolu]

I am trying to schedule a job which contains several reports that we run manually each month.  I would like to know how do I hard code the current and previous month into the reports so that they can be scheduled verses manually running them each month.

[dlafrance]

Are you using a cube or a relationnal datasource ?

[tolu]

relational

[dlafrance]

The only way i see of doing this, is by using where clause that filter your data based of the current_date.

Functions like first of month can be helpful if you want to split values in 2 field (current month and last month)