Field Details: coll_days_overdue

Back to Fields
Basic Information
Field Name: coll_days_overdue
Source Table: evolved_records
Version: 1
Expression Type: jinja
Output Type: INTEGER
Status: Active
Created: 2025-10-16 04:31:29
Updated: 2025-10-16 04:31:29
Metadata
Display Name: Days Overdue
Categories: COLLECTIONS
Group: Collection Metrics
Usage
Used in Summary: Yes
Used in Template: No

Description

No description available

Expression

            {% if raw_data.due_date %}
                {% set due_date = raw_data.due_date|to_date %}
                {% set today = today() %}
                {% if today > due_date %}
                    {{ (today - due_date).days }}
                {% else %}
                    0
                {% endif %}
            {% elif raw_data.aging_days is defined %}
                {{ raw_data.aging_days }}
            {% else %}
                0
            {% endif %}