display month name 1

[Durango122]

Hi All
cr 9.0
ms sql
i would like to display month name and year number from this formula
totext(Date(year({?Date}),month({?Date}),1),"MM/yyyy")

reight now it gives me this 01/2007
would like January 2007

thanks


Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40

 

[synapsevampire]

Try:

monthname(month({?date})) & ", " & totext(year({?Date}),0,"")

Change the ", " to whatever you want inbetween them.

-k

 

[Durango122]

hi -k
i used this one
MonthName(Month({?Date})) + " / " +
ToText(Year({?Date}),0,"")
works the same

Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40

 

[lbass]

Or use:

totext(Date(year({?Date}),month({?Date}),1),"MMMM yyyy")

-LB

 

[buck149]

As a matter of fact, you can format the parameter instead of using a formula to force the display of month name. If you insert the paramter into the report and right click and to to format object, select date, you will see "March 1999" just select this and it is done.

 

[lbass]

Yes, that's the simplest. Wasn't thinking.

-LB