Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
between trunc(sysdate-7) and trunc(sysdate)
- Thread starter TCOEN
- Start date
Drag the date field from your table to the limit line. Select custom SQL and set the date field to <= sysdate. Drag the same date field from your table to the limit line again. This time set it to => sysdate-7. This should return all data for the last 7 days. Hope this help.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question