I have this formula

 

IF MONTH({INVENTORY_TRANSACTION_HIST2.DATE_CREATED}) =  month(dateadd('m',-1,((currentdate))))
AND {INVENTORY_TRANSACTION_HIST2.TRANSACTION_CODE} in 'BACFLUSH''SOISS'
THEN {INVENTORY_TRANSACTION_HIST2.QUANTITY}
ELSE 0

 

which returns qtys for certain transaction codes for last month from the current date.

 

The problem is that it is also returning data from 13 months ago.

 

I have columns for current month and 1 - 6 months ago in the report

 

How do I set the year as well?

I can't just use the select expert to pick this year as when the report is run next month it will not return data for Jan 2012?

 

Many Thanks for any help

Gav

 

 

I really should start thinking more logically!!!!