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