Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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