Six months back to CurrentDate/ChangeDate

[ebstarasia]

I have a crosstab that I am trying to display data starting from the currentdate or even date specified (preferably)to six months back from specified date.


{v_oimaster.CREATEDATE} in date(year({?change date}),month({?change date}-6),day({?change date}) to {?change date}

where {?change date} is 1/14/2012

The formula above is not working. Its not displaying anything.

 

[lbass]

Two changes:

{v_oimaster.CREATEDATE} in date[red]serial[/red](year({?change date}),month({?change date}[red])-6[/red],day({?change date})) to {?change date}

-LB