Hi Jack,

Yes, you could use the DATEDIFF and TODAY functions with the timestamp of your activity table.

The PQL will be something like this:

DATEDIFF (dd, ACTIVITY_TABLE.EVENTTIME, TODAY()) ----This will give you the time in days between your activity and today's date

Here is some additional information about this functions:

DATEDIFF: https://docs.celonis.com/en/datediff.html#UUID-c5dab9a3-1b0d-e39b-021c-79857e628555

TODAY: https://docs.celonis.com/en/today.html#UUID-9dd7e754-0f18-5285-d4d2-42f99299bdd8

Hope this helps.

and if I need to calculate with the end of the month date?