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 %}
© SimSol Technologies and Services Private Limited