Categories
- All Categories
- Oracle Analytics Learning Hub
- 33 Oracle Analytics Sharing Center
- 22 Oracle Analytics Lounge
- 255 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 97 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
We are moving this forum's discussions to a new location. During this transition, this forum will become read-only starting 15th January 2026. For any new questions, please email us at analytics-community-ww_mb@oracle.com. Thank you for your understanding and continued participation!
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Count days function in subject area
Saher
Rank 4 - Community Specialist
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.
0
Best Answer
-
Hi, you can use the below formula
TIMESTAMPDIFF(SQL_TSI_DAY, <Task Assigned Date> ,CURRENT_DATE)
Raghu
1
Answers
-
Thanks, that works for me.
0