Hello,
I am trying to create a slice that will select cars that have:
Below is the slice expression that I wrote. The expression is not quite capturing the correct records.
AND
(OR([RentalStatusID]=2,[RentalStatusID]=5,[RentalStatusID]=3),
OR((AND([RentalDate] >= (TODAY() - 14),[RentalDate] <= TODAY())),
AND([RentalDate] <= (TODAY() + 7),[RentalDate] <= TODAY())))
Any ideas?
Thanks,
Alex
Solved! Go to Solution.
Thank you Marc and Steve,
After I changed the
โ [RentalDate] <= TODAY()โ
to
[RentalDate] >= TODAY()
, at the end of expression, the formula worked.
Marcโs expression worked as well. I learned something new with the LIST expression.
User | Count |
---|---|
43 | |
30 | |
26 | |
14 | |
14 |