# Calculate number of days in the KReport

**URL:** <https://community.spicecrm.io/t/calculate-number-of-days-in-the-kreport/794>\
**Category:** KReporter\
**Created:** [May 27, 2026, 1:20pm UTC](https://community.spicecrm.io/t/calculate-number-of-days-in-the-kreport/794 "2026-05-27T13:20:35Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![rsp](https://avatars.discourse-cdn.com/v4/letter/r/4491bb/32.png) [@rsp](https://community.spicecrm.io/u/rsp)\
**Post date:** [May 27, 2026, 1:20pm UTC](https://community.spicecrm.io/t/calculate-number-of-days-in-the-kreport/794/1 "2026-05-27T13:20:35Z")

</div>

Hello @maretval

We want to calculate the number of days and display them in the columns of the KReport.

We have Created Date and Modified Date fields in the record, and we want to know how many days have passed since those dates until today.

How can we add these two columns?

---

<div class="post-metadata">

**Author:** ![rsp](https://avatars.discourse-cdn.com/v4/letter/r/4491bb/32.png) [@rsp](https://community.spicecrm.io/u/rsp)\
**Post date:** [May 27, 2026, 1:51pm UTC](https://community.spicecrm.io/t/calculate-number-of-days-in-the-kreport/794/2 "2026-05-27T13:51:27Z")

</div>

## The below worked for us 🤩 🥳 💯

```plaintext

DATEDIFF(NOW(), {t}.date_entered)

DATEDIFF(NOW(), {t}.date_modified)

```

* * *

If you have the field with date type:

> DATEDIFF(NOW(), YOUR\_DATE\_FIELD)