Static Date Range

[itguymike]

i want to use a static date range on a exp date report for products. i have the following:
{TRACE.EXPIRATION_DATE} in (CurrentDate) to (CurrentDate+14)

when i add it to the report i get only no records. if i create a parameter for a date range and use that instead it gives me pages of expiration dates between the variable dates. what am i doing wrong on the static formula? any ideas?

thanks for your help

 

[Charliy]

I don't see anything wrong. Try this: date({TRACE.EXPIRATION_DATE}) in (CurrentDate) to (CurrentDate+14)


It may not let you do that, depends on the field type.

 

[itguymike]

ran it with the new code and it showed 2 items only. the exp dates of the product that showed was 7/15/14