Hi there,

I'm working on a shipment report that shows what's available to ship from everything in the past, up to two months from current date.

I have this formula, the section marked in Bold is the one i need help with to give me the data i need:

I set it in actual dates because i don't know how to write it otherwise

{V_ARINVT_AVAIL_DTL.ON_HAND} >= {V_ARINVT_AVAIL_DTL.SHIP_QUAN} and
{V_ARINVT_AVAIL_DTL.TRAN_DATE} in Date(2010, 01, 01) to date(2017, 12, 31)

Please help me :(

no what i need is two months forward