Count days function in subject area

Question

Hi Everyone,

Is there a way to count days in the subject area?

I'm working on a checklist subject area, where I want to count task-assigned days.

The report count days logic should be (current date - task assigned date). For example, if the Person task assigned date is September 1, 2023, and the current date is September 18.2023, then the days count should be 18.

Thanks.

Raghavendra Raghunath-Oracle · Accepted Answer

Hi, you can use the below formula

TIMESTAMPDIFF(SQL_TSI_DAY, <Task Assigned Date> ,CURRENT_DATE)

Raghu