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

Display the dates for LastFullWeek

Status
Not open for further replies.

cretanion

Technical User
Jan 28, 2002
53
US
How do you display the dates from: and to: if you use the Date Range "LastFullWeek" to run a report

thank you in advace.
 
totext(minimum(lastfullweek),"MM/DD/YYYY") + " to " +
totext(maximum(lastfullweek),"MM/DD/YYYY")
 
Write a formula:

"This report covert the date range of "&totext(minumum(LastFullWeek))&" to "&totext(maximum(LastFullWeek))

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
 
That was too easy, thanks dgillz as your formula worked when the ),"MM/DD/YYYY") is removed from it.
 
Sorry. I should have clarified and I gave you an incorrect format, too. It should have been "MM/dd/yyyy".

If you want to display the full date (i.e. February 20, 2005) then you can leave off the format.

I was assuming you wanted it in 02/20/2005 format

-LW

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top