Month Name and year 1

[fhurmuzlu]

Hello,

I am trying to put the Month Name and year on a report using a text box formula.

anybody knows the formula for Month name and Year Formula.

Thanks in Advance.

 

[lbass]

Of what field? Let's say it is a parameter {?Date}. Then create a formula like this:

monthname(month({?Date}))+" "+totext(year({?Date}),"0000")

You can use this formula directly or drop it into a text box.

-LB

 

[crystalkiwibruce]

I find ToText more useful with a date mask
ToText({?Date Value},"MMMM yyyy")

Bruce Ferguson

http://www.crystalkiwi.com/nlog.htm