Question

Ageing report

0

Hello experts, We want an ageing report just to show how many days the record is sitting there in the database. Based in current date and time, How to achieve this in Mendix?

asked 2021-09-23

Harsh Joshi

1 answers

Abhishek Devaraj · Answer 1 · 2021-09-23

Hi Harsh,

You can enable the Store CreatedDate in your entity and then use a Microflow to calculate the days between the Created Date and Current Date, this shoould give you the age of the record. You can either store this calculation in an attribute of the same entity per record or use a Calculated attribute for the same if its not going to impact performance. Hope this heps. Good Luck.