Previous Week

[system]

I need to display data in the report for previous week.
The report does not have any date prompts.

I need to create a filter in the designer on date object
week starts - Monday
week ends - Sunday
Data base Oracel

Eg: if i run the report any day on this week ,it should display data from
23 june to 29th june

Please help me ! Thankyou

---

SAPBOBJ567 (BOB member since 2013-10-24)

[system]

Hi,

User relative date functions as mentioned in this old topic:

Oracle Relative Date Functions

Just thought I’d help people out by posting some as a quick reference Yesterday: trunc(sydate)-1 Today: trunc(sysdate) Start of Current Month: trunc(sysdate,'mm') End of Current Month: last_day(sysdate) Start of Previous Month: trunc((trunc(sysdate,'mm')-1),'mm') End of Previous Month: trunc(sysdate,'mm')-1 Start of Current Quarter: trunc(sysdate,'q') End of Current Quarter: add_months(trunc(sysdate,'q'),3)-1 Start of Previous Quarter: trunc(trunc(sysdate,'q')-1,'q') End of Previous Qu…

---

Marek Chladny (BOB member since 2003-11-27)