need help with date in r/s 1

[ncchish]

Can anyone tell me the correct syntax for this for the r/s? I'm using CR11. I need to get the date from 2 different sources to get accurate results. Before I was using table.DAY_REPT_DATE = {?DateRange} but in certain situations we are not getting all the data at first of month or end of month. We need to pull month, year from another sourc. Any help is appreciated. Thanks.


{table.CLNDR_MNTH},day({table.DAY_REPT_DATE}, {table.PRODYEAR}) = {?DateRange} and

 

[lbass]

date({table.PRODYEAR},{table.CLNDR_MNTH},day({table.DAY_REPT_DATE})) = {?DateRange}

Took me a while to figure out "r/s".

-LB