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!

Creating Date field to show yesterday's date

Status
Not open for further replies.
CCMKEENER

CCMKEENER

MIS
Oct 6, 2003
2
US
I am trying to create a field I can use in my reporting to reference "Yesterday's" date. basically I am looking for a formula, or steps needed to add a (Current Date-1) field to my databases.
 
Sort by date Sort by votes
Pretty close:

Select Insert->Field Object->Right click formulas and select New, name it, and place:

currentdate-1

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

Similar threads

T
  • Locked
  • Question
Date comparison Formula
Replies
2
Views
484
TPG_IT
T
D
  • Locked
  • Question
Comparing two Date Ranges
Replies
0
Views
311
doodledump
D
B
  • Locked
  • Question
Difference of a field between 2 variable dates
Replies
1
Views
225
hilfy
hilfy
chish_nc
  • Locked
  • Question
Need help getting oldest anniversary date to show
Replies
3
Views
258
pmax9999
pmax9999
socalvelo
  • Locked
  • Question
Extract Phone Numbers from Text Field
Replies
0
Views
258
socalvelo
socalvelo

Part and Inventory Search

Sponsor

Back
Top