Formatting the Year in a Formula

[tmozer]

@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"??

 

[butkus]

Try this

totext(int((year(currentdate),0,"")))

James

 

[butkus]

Sorry, I just copied and pasted your portion, It should be this:
totext(int(year(currentdate),0,""))

James

 

[butkus]

Sorry again, I'm typing faster than I'm thinking this morning

totext(year(currentdate),0,"")

returns what you want.

James

 

[chelseatech]

you could also use
ToText(CurrentDate,"yyyy")

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[kskid]

I use the following with my 8.5 reports

"Commulative Cases/Assignments Received for " + cstr(currentdate,"yyyy")

 

[bdreed35]

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

 

[kskid]

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")

 

[tmozer]

Thank you all!!