Errors when using Collect function

David Hinman

I keep getting an error when I use the collect function. I'm trying to return the most future date in a column of dates. There are no blanks, all rows are populated. I've checked and all rows are dates.

COLUMNS:
* Line Item Renewal Date = date
* Application Name = Text

=MAX(COLLECT([Line Item Renewal Date]:[Line Item Renewal Date], [Application Name]:[Application Name], [Application Name]@row))
—> #INVALID COLUMN VALUE
——→ This is the only one where the formula has the colors that indicate the tool recognizes it as a formula.

=MAX(COLLECT({Line Item Renewal Date}, {Application Name}, [Application Name]@row))
—> #INVALID REF

=MAX(COLLECT([Line Item Renewal Date], [Application Name], [Application Name]@row))
—> #UNPARSEABLE

So. What am I doing wrong here? I've seen variations of how to enter this and I cannot crack this.

Kelly Moore

Hey @David Hinman

What column type is the column where your Max/Collect formula sits? It also needs to be a date type column since the data you are collecting is a Date.

Kelly

Kelly Moore

Hey @David Hinman

What column type is the column where your Max/Collect formula sits? It also needs to be a date type column since the data you are collecting is a Date.

Kelly

David Hinman

You've got to be kidding me. That was it? I guess I'm used to Excel which would return a value as a number and I'd use the formatting to convert to a Date. Thanks!