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!

Yesterday's date in record selection

Status
Not open for further replies.
redbunny78

redbunny78

Programmer
Joined
Sep 26, 2007
Messages
29
Location
US
Crystal 9 and Oracle

How can I limit my record selection to just yesterday. I tried the formula CurrentDate - 1 but get an error.

How do I need to change this formula?

Thanks!
 
Sort by date Sort by votes
I fixed it, I left the in out...

Thanks!!!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

inkbird01
  • Locked
  • Question Question
Filters > Record Selection for dates between
Replies
4
Views
874
pmax9999
pmax9999
T
  • Locked
  • Question Question
Date comparison Formula
Replies
2
Views
2K
TPG_IT
T
D
  • Locked
  • Question Question
Comparing two Date Ranges
Replies
0
Views
630
doodledump
D
D
  • Locked
  • Question Question
Dynamic field height in crosstab?
Replies
0
Views
173
doodledump
D
PJ222
  • Locked
  • Question Question
is date within any date range in a dynamic array of date ranges
Replies
1
Views
452
PJ222
PJ222

Part and Inventory Search

Sponsor

Back
Top