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 derfloh 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
Joined
Dec 14, 2005
Messages
56
Location
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
Thanks Synapse....
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

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

Part and Inventory Search

Sponsor

Back
Top