Date selection help

[vega83]

Friends here is my selection criteria
{Command.ADDED_DT} in CDate(CSTR(Month(DateAdd("m",-13,{?Date})),0,'')&"/1/"
&CSTR(Year(DateAdd("yyyy",-1,{?Date})),0,'')) to {?Date}

I am getting only 12 months, i,c if i slect may2009, i am getting data from May2009 to june 2008 not may 2009 to may2008, Any reason? How can i achieve to get 13 months?.
THanks a ton,
V

 

[IanWaterman]

Chnage sect to -14

{Command.ADDED_DT} in CDate(CSTR(Month(DateAdd("m",-14,{?Date})),0,'')&"/1/"
&CSTR(Year(DateAdd("yyyy",-1,{?Date})),0,'')) to {?Date}

Ian

 

[vega83]

Ian, I have already tried it once, but still i get same 12 months only

 

[IanWaterman]

Are sure that your data set goes back to May 2008.

Create a formula
@test
CDate(CSTR(Month(DateAdd("m",-14,{?Date})),0,'')&"/1/"
&CSTR(Year(DateAdd("yyyy",-1,{?Date})),0,''))

Place in report and see what is returned.

Ian

 

[vega83]

Yes, it does when I select july09 it goes back only till aug 08

 

[lbass]

I answered this in your other post.

-LB