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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to get previous Sundays date? CR8.5 1

Status
Not open for further replies.
Digitalcandy02

Digitalcandy02

MIS
Joined
Nov 18, 2003
Messages
5
Location
US
I would like to get the previous Sunday date for any given date field. Can anyone help out with the formula?

Thanks
 
Sort by date Sort by votes
{table.date} - dayofweek({table.date}) + 1

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

Similar threads

tlbrown88
  • Locked
  • Question Question
How does one get the results of a Calculation (SharedVar) on the same line as the Sub Report?
Replies
4
Views
973
tlbrown88
tlbrown88
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
629
doodledump
D
chish_nc
  • Locked
  • Question Question
Need help getting oldest anniversary date to show
Replies
3
Views
577
pmax9999
pmax9999
PJ222
  • Locked
  • Question Question
is date within any date range in a dynamic array of date ranges
Replies
1
Views
448
PJ222
PJ222

Part and Inventory Search

Sponsor

Back
Top