Rollup & Max & Dates & Formulas & Formatting = Loop / Freeze


#1

MAX(values) doesn’t work properly in the scenario where you rollup a date field which uses formatting. It’s no longer recognised as a date and can cause problems.

It also looks like old field level formatting is stored when a datatype changes. I used an existing field that was formatted for currency and changed the formula to simply show a date field. My rollup in the parent record caused a major problem later on although the child field appeared as it should: I was locked out the parent table as it got stuck on the ‘Loading’ screen.

To re-enable access to that table I had to change the formula in the child table.

FYI. :slight_smile:


#2

I think I’m having a similar issue. I’m trying to use MAX() to return the most recent date from two rollup fields, but it doesn’t work as expected.

The formula MAX({Rollup Date 1}, {Rollup Date 2}) returns 0

while the formula ‘DATETIME_PARSE(MAX({Rollup Date 1}, {Rollup Date 2}))’ returns 1/1/1970