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 John Tel 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
Apr 25, 2001
18
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
Comparing two Date Ranges
Replies
0
Views
428
doodledump
D
T
  • Locked
  • Question
Date comparison Formula
Replies
2
Views
2K
TPG_IT
T
PJ222
  • Locked
  • Question
is date within any date range in a dynamic array of date ranges
Replies
1
Views
293
PJ222
PJ222
socalvelo
  • Locked
  • Question
Date Range Formula - Data from two months ago only
Replies
4
Views
543
pmax9999
pmax9999
ejastia
  • Locked
  • Question
date format spacing 1
Replies
4
Views
403
ejastia
ejastia

Part and Inventory Search

Sponsor

Back
Top