Date Range (from past to two months forward)

Printed From: Crystal Reports Book — Forum Name: Technical Questions

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 :(
two months ago today would be
dateadd('m',-2,today)
no what i need is two months forward
ok i think i figured it out?? i changed the minus to a plus lol and it worked! thanks!