Mar 3, 2005 #1 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.
How do you display the dates from: and to: if you use the Date Range "LastFullWeek" to run a report thank you in advace.
Mar 3, 2005 #2 kskid Technical User Mar 21, 2003 1,767 US totext(minimum(lastfullweek),"MM/DD/YYYY") + " to " + totext(maximum(lastfullweek),"MM/DD/YYYY") Upvote 0 Downvote
Mar 3, 2005 #3 dgillz Instructor Mar 2, 2001 10,045 US 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 http://www.gainfocus.biz Upvote 0 Downvote
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 http://www.gainfocus.biz
Mar 3, 2005 Thread starter #4 cretanion Technical User Jan 28, 2002 53 US That was too easy, thanks dgillz as your formula worked when the ),"MM/DD/YYYY") is removed from it. Upvote 0 Downvote
Mar 3, 2005 #5 kskid Technical User Mar 21, 2003 1,767 US 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 Upvote 0 Downvote
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