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!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report Header using a CR date range

Status
Not open for further replies.

thorny00

Programmer
Feb 20, 2003
122
US
Using CR 10.0
Want to show the week to date from Sun function in my report header. Below is what I have but it isn't working.
Any ideas

"Hours worked for" & " " & GroupName ({tblProjectsLog.User}) &
" Period of" & totext(WeekToDateFromSun)

Would like it to show:
Hours worked for Joe Smith Period of 12/4/05 - 12/9/05

Thanks for the help, I appreciate it!!
 
Change the period to:

" Period of" & minimum(WeekToDateFromSun) & " - " & maximum(WeekToDateFromSun)

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top