Hello,
I need to create an aging formula with an If statement to track when a record is open with a count of days until it gets closed and ultimately stops counting. I then want to be left with the difference of days between the date opened and the date completed, in the days-old column. Currently, the Days old column counts days open from the date the record was created. DATETIME_DIFF(TODAY(), DATETIME_PARSE({Opened date}, 'MM-DD-YY'), 'days') and just keeps counting. Any help is appreciated!