CurrentMonth and Year

[Steve95]

Hi All

I need to know how to compile a formula showing current month and year as one field e.g. October 2005....

Many Thanks in Advance

 

[dgillz]

Assumming you have a date or date-time field, just format the field to display this way.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[Steve95]

That is it, this information needs to be displayed on a coverpage...so this report has no datasource, just has a pic, text box and a need a current month and year displayed eg. October 2005.

Many Thanks

 

[stillsteam]

I use this in 8.5

LeadingCaps (Monthname(Month(currentdate)))&" "& Totext(Year(Currentdate),0,"")

/Jonas

 

[Steve95]

Thanks

also figured out do a month formula and year formula and then add both to a text box...

Cheers

 

[bdreed35]

Sounds like you over complicated it.

You could of just placed the PrintDate special field on the report and then just formatted it to display like "October 2005"

or

If you did a formula, you could have have just used the ToTect function:

ToText(CurrentDate,"MMMM yyyy")

~Brian