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