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!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Selection criteria on Date

Status
Not open for further replies.
busi1

busi1

Technical User
Dec 14, 2005
56
US
Hi,

I have a date field called Table_create_date.It should select the data of previous seven days everytime i run the report.

I am using crysatl 10.0 and oracle 9

Thanks,
 
Sort by date Sort by votes
Use Report->Selection Formulas-REcord and place:

(
Table_create_date >= currentdate-7
and
Table_create_date <= currentdate-1
)

-k
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennymc
  • Question
Has anyone used Crystal reports with online Microsoft Dynamics 365
Replies
0
Views
144
Kennymc
Kennymc
MusicMan123
  • Locked
  • Question
Record Selection Formula Help
Replies
0
Views
277
MusicMan123
MusicMan123
Corinne30
  • Locked
  • Question
Duplex Printing of Postcard reminders - Not printing back on last page.
Replies
1
Views
453
hilfy
hilfy
rwwagner
  • Locked
  • Question
Passing date range formula from main report to sub report
Replies
2
Views
644
lbass
lbass
PeteyN.O
  • Locked
  • Question
Crystal Report passing a date parameter to a number type field
Replies
3
Views
321
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top