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

Current Full Week

Status
Not open for further replies.
aproddut

aproddut

Programmer
Oct 29, 2002
15
US
Hello,
I am using Crystal 7.0 . Can anyone tell me how do i write th report selection criteria so it gets data only for the current full week (starting from sunday until now)

Thanks,
Ash
 
Sort by date Sort by votes
Here is one way:
{date.field}>=(currentdate-dayofweek(currentdate)+1)

"why it works"
If today were Thursday the 24th of July, it's day of week is 5. The formula subtracts 5 day resulting in Saturday the 19th then adds on to make it Sunday the 20th (this week)

Mike
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Deaconskye
  • Locked
  • Question
Display the current week of data - Crystal Reports 2016
Replies
1
Views
81
IanWaterman
IanWaterman
borisbe
  • Locked
  • Question
Calculating the Number of Weeks between Dates. Only held on certain days of week (Problem: Holidays)
Replies
1
Views
80
Charliy
Charliy
TechSlinger
  • Locked
  • Question
Denominator for Day of Week?
Replies
1
Views
39
hilfy
hilfy
Danster
  • Locked
  • Question
Print full last page, no headers or footers
Replies
3
Views
157
pmax9999
pmax9999
ridhirao22
  • Locked
  • Question
Exported format to excel doesn't print on full page
Replies
2
Views
59
ridhirao22
ridhirao22

Part and Inventory Search

Sponsor

Back
Top