Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
How can I display the date of last Friday for a set of data?
I should get a data for last 2-weeks from current date but the report date(displaying in the output) should be every friday for the respective weeks in OTBI. I got the data for last two weeks but the report date should be the date of friday in that week.
When we compare with the below image, let's consider the report is run on 01/07/2022 . So I should get last two week data ( 2 week data in the sense 25th jan to 7th Feb). But the reporting date should be friday for those two weeks (i.e 31st Jan and 7th Feb). 31st Jan should be displayed for the data from 25th Jan to 31st Jan and 7th feb should be displayed for the data from 1st Feb to &th Feb.
Answers
-
Please don't post duplicates: https://community.oracle.com/tech/apps-infra/discussion/4494337/how-can-i-display-the-date-of-last-friday-for-a-set-of-data#latest
Keep your work contained to one thread as double posting will spread out things over 2 places - which doesn't help anyone - and is hence against community standards.
0 -
I'm locking this duplicate.
0