Schedule last day of the month?

Is there any way to schedule a report to run only on the last day of the month?

RS doesn't support a scheduling a report on the last day of the month since the dates vary from 28 to 31.

However, you can schedule one on the first day of the month at 12:01am.

HTH....

--
Joe Webb
SQL Server MVP

~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)

|||The ability to schedule based on an expression would be high on my wishlist. The inability to schedule something on the last day of the month is a rather significant design flaw.