In addition to a MTD formula, a report uses this formula:

if {SRW90 Transactions.Date} in LastYearMTD then {SRW90 Transactions.Sales amount} else 0.

It will never pick sales from Feb 29, 2012. What can I do to get those on the report?

My client strongly prefers not to enter a runtime value when running his reports, but basing all formulas off the report date.

Thanks

Steve

This is the reason we recommend to NEVER use February 29th as a "business day" - it makes comparative reporting a bear. Not only will you not pick up the February 29 transactions, but you'll get a date calculation error on February 29 since the date does not exist in the year prior.

To get the last day on ANY month, subtract 1 from the first day of the month following. Generally, you'll want to find out whether you are running a report on the last day of the month. Do that with:

Thanks Andrew

I think this might do the trick. I'll try it out tomorrow.

Steve

Hi Andrew

It turns out that your formula works if you change the first row to:

IF MONTH(TODAY() + 1) = MONTH(TODAY()) then

(with the 1 inside the parens)

Thanks

Steve