I am trying to create a slice that will select cars that have:
- A certain rental status (either 2, 5, or 3) and
- A rental date that is between 14 days old and 7 days after the current date.
Below is the slice expression that I wrote. The expression is not quite capturing the correct records.
OR((AND([RentalDate] >= (TODAY() - 14),[RentalDate] <= TODAY())),
AND([RentalDate] <= (TODAY() + 7),[RentalDate] <= TODAY())))