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

First Day of Week - Title

Status
Not open for further replies.
qcman

qcman

Technical User
Jul 20, 2004
30
0
0
US
I want my report to show the first day of the week in the title. My query is for the lastfullweek and my formula in my title is minimum({datefield.field}). If I don't have any data for Sunday the title displays the minimum date. How can I show the first day of the week (Sunday)in my title?
 
Sort by date Sort by votes
Use:

minimum(lastfullweek)

If this is in the context of a string formula, use:

totext(minimum(lastfullweek),"MM/dd/yyyy")

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

Similar threads

RoknRole
  • Locked
  • Question
Static parameter list of values limitation
Replies
1
Views
77
RoknRole
RoknRole
Corinne30
  • Locked
  • Question
Duplex Printing of Postcard reminders - Not printing back on last page.
Replies
1
Views
71
hilfy
hilfy
1tufgt
  • Locked
  • Question
Creating Chart with formula of running total of group?
Replies
6
Views
126
lbass
lbass
nerdygirlgear
  • Locked
  • Question
Formula evaluating a list of 50 values that are strings.
Replies
1
Views
52
1tufgt
1tufgt
Deaconskye
  • Locked
  • Question
Display the current week of data - Crystal Reports 2016
Replies
1
Views
32
IanWaterman
IanWaterman

Part and Inventory Search

Sponsor

Back
Top