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!

Date Range

Status
Not open for further replies.
joseph1111

joseph1111

MIS
Joined
Apr 25, 2001
Messages
18
Location
US
I am fairly new to Crystal and wanted to know if anyone could tell me how to set up a report to always use yesterday's date. I want to run it and have it pull yesterdays sales totals without having to put in a date. I'm using v8.0 Thanks in advance.
 
Sort by date Sort by votes
In your record selection criteria you could use

{tablename.datefieldname} = CurrentDate -1
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

D
  • Locked
  • Question Question
Comparing two Date Ranges
Replies
0
Views
623
doodledump
D
T
  • Locked
  • Question Question
Date comparison Formula
Replies
2
Views
2K
TPG_IT
T
PJ222
  • Locked
  • Question Question
is date within any date range in a dynamic array of date ranges
Replies
1
Views
445
PJ222
PJ222
socalvelo
  • Locked
  • Question Question
Date Range Formula - Data from two months ago only
Replies
4
Views
789
pmax9999
pmax9999
ejastia
  • Locked
  • Question Question
date format spacing
Replies
4
Views
651
ejastia
ejastia

Part and Inventory Search

Sponsor

Back
Top