Creating a DIFF Attribute in BI Publisher Analysis Report

Summary:

Creating a DIFF attribute in BI Publisher analysis that provides an "aging count" of two date attributes from two separate subject areas. The aging count is blank. The assumption is because of the two different date formats, "M/d/yy h:mm t" and "M/d/yy."

Content (please ensure you mask any confidential information):

I'm currently facing a challenge in BI Publisher that I could use some guidance on.

In my analysis report, I'm working with data from two different subject
areas: CRM - Pipeline and a Custom Financial Aid object. The goal is to
create an aging analysis report based on two date attributes. However,