Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations 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