Join Collect formula to list Trucks Rented over 6 months

Amanda MedinaIW

Hello,

I need to create a list of vehicles that have been rented longer than 6 months. Below is the formula I am using. It is returning Incorrect Argument set.

=JOIN(COLLECT([VIN Number / Número VIN]:[VIN Number / Número VIN], [Date Rented]:[Date Rented], TODAY(-132), CHAR(10)))

JCluff

Parenthesis was missing after TODAY() formula. Updated formula below:

=JOIN(COLLECT([VIN Number / Número VIN]:[VIN Number / Número VIN], [Date Rented]:[Date Rented], TODAY(-132)), CHAR(10))