I'm using Rollup Helper to calculate the most recent activity date based on filter criteria. Because the date that Rollup Helper provides isn't that pretty, I'm converting that text into a DateValue then using the newly created DateValue to count the number of business days.
Everything seems to be working fine on the Opportunity, but when I pull this information into a report, I'm getting a #.ERROR! message. I read somewhere that there may be a compile size limit or something, but I really need this information on the report. Any suggestions?
That's weird! Shot in the dark: Instead of a direct DATEVALUE call can you try this =
DATE(
VALUE(LEFT(Date_Field_From_RUS__c, 4)),
VALUE(MID(Date_Field_From_RUS__c, 6, 2)),
VALUE(MID(Date_Field_From_RUS__c, 4, 2))
)
