Oct 13, 2004 #1 tmozer Programmer Sep 11, 2004 66 0 0 US @ReportTitle formula in CR 8.5: "Commulative Cases/Assignments Received for " + MonthName(month(currentdate)) + " " + totext(int((year(currentdate)))) My year keeps printing as "2,004.00" no matter what I try. How can I format to "2004"??
@ReportTitle formula in CR 8.5: "Commulative Cases/Assignments Received for " + MonthName(month(currentdate)) + " " + totext(int((year(currentdate)))) My year keeps printing as "2,004.00" no matter what I try. How can I format to "2004"??
Oct 13, 2004 #2 butkus MIS Sep 4, 2001 114 0 0 US Try this totext(int((year(currentdate),0,""))) James Upvote 0 Downvote
Oct 13, 2004 #3 butkus MIS Sep 4, 2001 114 0 0 US Sorry, I just copied and pasted your portion, It should be this: totext(int(year(currentdate),0,"")) James Upvote 0 Downvote
Sorry, I just copied and pasted your portion, It should be this: totext(int(year(currentdate),0,"")) James
Oct 13, 2004 #4 butkus MIS Sep 4, 2001 114 0 0 US Sorry again, I'm typing faster than I'm thinking this morning totext(year(currentdate),0,"") returns what you want. James Upvote 0 Downvote
Sorry again, I'm typing faster than I'm thinking this morning totext(year(currentdate),0,"") returns what you want. James
Oct 14, 2004 #5 chelseatech Instructor Aug 25, 2001 1,812 0 0 NZ you could also use ToText(CurrentDate,"yyyy") Editor and Publisher of Crystal Clear http://www.chelseatech.co.nz/pubs.htm Upvote 0 Downvote
you could also use ToText(CurrentDate,"yyyy") Editor and Publisher of Crystal Clear http://www.chelseatech.co.nz/pubs.htm
Oct 14, 2004 #6 kskid Technical User Mar 21, 2003 1,767 0 0 US I use the following with my 8.5 reports "Commulative Cases/Assignments Received for " + cstr(currentdate,"yyyy") Upvote 0 Downvote
I use the following with my 8.5 reports "Commulative Cases/Assignments Received for " + cstr(currentdate,"yyyy")
Oct 15, 2004 #7 bdreed35 Programmer Mar 2, 2003 1,549 0 0 US Here is my version: "Commulative Cases/Assignments Received for " + totext(currentdate, "MMMM yyyy") It takes care of your Month Name and year in the same function. ~Brian Upvote 0 Downvote
Here is my version: "Commulative Cases/Assignments Received for " + totext(currentdate, "MMMM yyyy") It takes care of your Month Name and year in the same function. ~Brian
Oct 15, 2004 #8 kskid Technical User Mar 21, 2003 1,767 0 0 US Bottom line.... ToText and Cstr are equivalent functions so the choice is yours Many of my monthly reports run after the close of the month to report the previous month's activity so I use the following "Activity Summary for " & cstr(Maximum(LastFullMonth),"MMMM, yyyy") Upvote 0 Downvote
Bottom line.... ToText and Cstr are equivalent functions so the choice is yours Many of my monthly reports run after the close of the month to report the previous month's activity so I use the following "Activity Summary for " & cstr(Maximum(LastFullMonth),"MMMM, yyyy")
Oct 15, 2004 Thread starter #9 tmozer Programmer Sep 11, 2004 66 0 0 US Thank you all!! Upvote 0 Downvote